Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Straight table issue

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

10 Replies
sunny_talwar

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)

Capture.PNG