Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys
I have a small pivot chart
which consists of 4 columns
If the result for the row, for 3 of the columns is zero, i do not want to see the row.
Is it possible to do this in an expression?
where 0 <> null I.e.
Aaron
Try using a Calculated dimension along the lines of
=IF(E1+E2+E3<>0,1)
And then tick the box on the dimension to suppress Nulls
Regards
Adrian
Can you share a snapshot of what you are seeing? May be check 'Suppress Zero Values' on Presentation tab of chart properties
Sorry Sunny i cannot.
There are 3 expressions
If the value in the same row for all 3 expressions is zero
I do not want the user to see it. Do you think this is possible?
Sample with a mocked up data? If that is something you are unable to do, then I will let someone else help you
Best,
Sunny
Aaron
Try using a Calculated dimension along the lines of
=IF(E1+E2+E3<>0,1)
And then tick the box on the dimension to suppress Nulls
Regards
Adrian