Forum Discussion
Removing 0 values in matrix
Hi everyone, So I have this matrix/table in BI Company IN OUT Tesla $100.00 $0.00 Microsoft $0.00 Square $100.00 $100.00 I want to remove the lines that have both...
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
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