Forum Discussion
Removing 0 values in matrix
I want to remove that row only. If I use the filter in any of the 2 columns it filters out the whole line which is not what I want.
Instead of trying to filter, I changed the calculated columns to show blanks instead of zero and that solved the problem
Hi Anonymous - In the matrix, can you clarify whether you would like the Microsoft row still to be shown as an empty row despite it having blank and zero values?
If you would like the blank/0 Microsoft row to remain, you could conditionally format the IN and OUT values to have the same colour of font as the background when the value equals 0.
This would mean that the zero value would be in the grid (and the row would remain) but the user wouldn't see the value so it would look 'empty' to them.
Cheers,
Richard
I want to remove that row only. If I use the filter in any of the 2 columns it filters out the whole line which is not what I want.
Instead of trying to filter, I changed the calculated columns to show blanks instead of zero and that solved the problem
Anonymous Am glad you found a solution