Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.