I have a standard pivot table with 4 items in the values area.
I am using the Sum of those values.
I want to filter out the zero's in one of those values.
I select the value from the Fields area and select Filter Values.
I set it for Not Equal 0
But the zero values still show up.
Suggestions?
thanks