Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dimension level 2 | Sum ( A & B ) | Sum ( C ) / Sum ( A & B ) | |
---|---|---|---|
Alpha | A | A | Null |
Alpha | B | B | Null |
Alpha | Null | Null | C |
Hi,
How can I hide the third line of my table (where dimension level 2 = null) and keep the result of my expression (Sum(C) / (Sum A & B) in the same time ?
I can make all values of the third line equals to null but the line doesn't not disappear.
In table properties, if I chose to not display null values the line disappear but my calculation ( Sum(C) / Sum(A & B) ) as well.
How can I hide the third line and keep my result ?
supress Dimension level 2
or
if([Dimension level 2]<>'Null',[Dimension level 2])
then supress null
Thank you for your answer.
However, I can't suppress Dimension level 2 because I still need to see A & B.
The if statment change Sum( C ) to null.
An easy way of doing it would be to create two tables but it would be nice to have only one table.
can you upload a sample file and out put required.