Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try to use option in chart properties >> dimension >> suppress When Value is Null option by selecting the dimension and apply that.
Regards
Anand
See attached qvw.
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
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.