Hide null values of a particular expression in a Straight Table

[Anonymous]

Hi,

I have a Straight Table where there there is a Single Dimension and multiple expressions.

All the Expressions except one are having values for all the rows.

The expressions are interrelated and the order cannot be changed.

What i need is ,i need to hide the rows whenever the last expression is having null values.

Could anyone please help in doing this?

[er_mohit · Accepted solution]

Ok so for this you have to make all expressions value 0 where match last expression column is 0. so, for this

in all expression column except the last expression column just put one condition

suppose your last expression column is 5.

For first expression column the logic you write is changed. before

you 'hv to write

=if(column(5)=0,0,

sum(value) )

do this for all expression and make sure in presentation tab there's check on suppress zero value if not then do it

Hope it helps

Regards

Mohit

[simondachstr]

I think he meant null and not 0

[Anonymous]

I cant do this because the calculation of fithe expr is dependent on the first 4 expression values

[Anonymous]

Thank you Mohit.It is working perfectly:)