How not to show lines where expressions result in 0?

[nenadvukovic]

Hi - In a pivot or straight tbale I would like to eliminate rows where the result of the set analysis = 0.

I've tried if(MyExpr = 0, null(), MyExpr) with Suppress Null Values but no luck

I've also tried Dimension Limits and no luck again

Thx

[#2]

Go to properties, Presentation, select the field you want to supress 0 values, and in the bottom left side of presentation flap you will see an option "Supress cero values"

Hope it helps!

Best regards!

Jonathan.

if this is what you looking for remember to mark as correct answer.

[jpenuliar]

Chart Properties, Presentation Tab, Tick/Untick "Suppress Zero Values"

[nenadvukovic]

This does not help. It is check by default.

In the expression part I've marked those I am not interested in as Null() as I wrote in my initial message. The question here is how tho show only lines marked in yellow? Thank you

[lironbaram · Accepted solution]

the reason the first two rows appears is because of the value in column 3

you need to put inside the expression reference to column 2 that says that if it's null then make the third column null also

second option is to replace the first expression with calculated dimension , that way you can suppress null

on the calculated dimension , you should note that this solution might cause performance issues

[nenadvukovic]

Thank you Liron. I used your first suggestion and got what I wanted to get.