honeyherrada
Board Regular
- Joined
- Apr 18, 2007
- Messages
- 56
Hello,
I would like to know how to hide the cells that contains zero values on my pivot table. The catch is that I have two columns that contains values...I tried hiding the columns that contains zero values but for some reason it also hides columns that contains values. For example: I have three columns on my Pivot Table:
Category # ##
Alpha 1 1
Bravo 0 1
Charlie 2 2
Delta 3 0
When I tried hiding the zero values under column #, it hides the whole row and it throws my totals off and vise versa with column ##.
Any ideas? Thanks!!
I would like to know how to hide the cells that contains zero values on my pivot table. The catch is that I have two columns that contains values...I tried hiding the columns that contains zero values but for some reason it also hides columns that contains values. For example: I have three columns on my Pivot Table:
Category # ##
Alpha 1 1
Bravo 0 1
Charlie 2 2
Delta 3 0
When I tried hiding the zero values under column #, it hides the whole row and it throws my totals off and vise versa with column ##.
Any ideas? Thanks!!