Filter out pivot results

[ljames88]

I created a pivot table expression which works well, however I only want to see totals that do not equal zero, or perhaps = 100, how can I do that so my pivot table only shows those types of results.  See below.  I have Total Bill as a column, but I only want to see the data when the Total Bill is not = 0

[sunny_talwar]

May be all you need to do is use an if statement for all your other expression to check if [Total Bill] > 0

If([Total Bill] > 0, Sum(QUANTITY))

If([Total Bill] > 0, ....)

....

And then once you do that, make sure you have checked 'Suppress Zero Values' on the presentation tab.