Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
I think he meant null and not 0
I cant do this because the calculation of fithe expr is dependent on the first 4 expression values
Thank you Mohit.It is working perfectly:)