Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I am searching on following problem.
I've created a straight table and with certain selections I generate the output below:
I don't want to see dimensions where all data is 0 or '-'. I only want to see the columns with actual data (6,5 and 4)
All options 'Suppress When Value is Null' are already flagged in the object.
Any other ideas/proposals?
Kind regards,
CM
Lol, then change your expression to this
=If(Column(2) <> 0, '')
Since you made division1 as your Column(1), use Column(2). Alternatively, you can use =If(A <> 0, '') (Column label)