How to exclude lines in a pivot table if 0 is result for an expression

[chriscools]

Hello,

i have a pivot table with a few dimensions and a few expressions.

one of these expressions is :

sum ( { < OrderStatus={"Placed", "On hold"}>} OrderPriceUnitNet * OrderQtyOpen) - sum ( {<Orderstatus = { " Placed", "On hold"}>} OrderPriceUnitNet * OrderQtyInPicking)

I would only that a line appears in my pivot table when te above expression is bigger then zero.

In the example attached i have 2008 lines, but only  23 of them have an "# open total" that is bigger then zero and therefore relevant.

What can i do to exclude these not relevant lines?

thanx very much!!!

grtz,

chris

[its_anandrjs]

Try to use option      in chart properties >> dimension >> suppress When Value is Null option by selecting the dimension and apply that.

Regards

Anand

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

[chriscools]

Hey Gysbert,

Thank you for your solution, it works perfect!!

i also tried supressing the null values on the dimension as Anand Chouhand suggest, but i guess this doesn't work because it's not the dimension which has null values, but the the calculated that must be seen as  a null just as you suggest?

grtz,

chris

[Gysbert_Wassenaar]

Yes, all the expressions should be zero in order for the row to be suppressed. There could be other ways of making sure of this, but those will likely perform worse.