Show only rows when first expression > 0 inPivot Table

[kris_vliegen]

Hi all,

Is there a way to show only the rows where the value of the first Expression is > 0?

I would only see the yellow rows in my Pivot table?

regards,

Kris

[prma7799 · Accepted solution]

If you have more than one column then you may be write  this

if (Column(1)> 0 , Sum(sales) , Null())

Or

Please share some sample app

[MK_QSL]

For each expression you have to use

If(Aantal >0, YourExpression)

[kris_vliegen]

Thanks,

this works. And then in the Presentation tab Suppress Zero-Values.

Regards,

Kris

[prma7799]

Good...