Hiding Zero Values in Pivot Table

[honeyherrada]

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!!

 

[Derek Brown]

Uncheck "Zero Values" on the View tab in the Tools | Options menu?

 

[honeyherrada]

I unchecked the "Zero Values" but it didn't change the table.

 

[Derek Brown]

That is strange - I just tried it and it works for me.

 

[Legacy 51064]

Have you tried re-arranging the data and then deleting the zeros?

Name Jan Feb Mar
Joe 1 0 1

to

Name Month Amt
Joe Jan 1
Joe Mar 1

 

[honeyherrada]

98illini,

I would've re-arranged the data, but decided to just sort my data and delete the cells that contains the zero values in both column.

Thanks d3p2j5b & 98illini for looking into this!