Removing '0' values in a pivot table

B

Browny

I know i've seen this Q&A before, but i can't remember how.
i want to remove lines with a '0' value from my pivot table.
 
S

Sheeloo

Filter out 0s.

If you just want to suppress the use CUSTOM number format

##.##;(##.##);;

Adjust ## according to your need.
 
Top