Hiding Zero Values in a Pivot Table - MS Excel 2007

[Taveras]

Does anyone know how to hide zero values in a pivot table in MS Excel 2007.
It used to be fairly simple in 2003 (just unchecking blank values or
something), but there doesn't appear to be an option for this in 2007. Does
anyone know how to do this? Thanks.

 

[Roger Govier]

Hi

Press the round Office button>Excel Options>Advanced>Display options for
this worksheet>un-check Show a Zero in cells that have zero values
This applies to the whole sheet, not just the PT.

You are perhaps confusing this with the new location for
In the PT itself, right click on any cell>Pivot Table Options>Layout &
Format> there is an options to check For Empty cell Show > decide on
character to be used.

 

[Taveras]

Hi -

Following those steps just makes the zero's come out as dashes.

What I'd like to do is remove or hide the entire rows that have zero values
in pivot tables. I guess maybe it wasn't clear from the post.

Thanks.

 

[Roger Govier]

Hi

You must have you data formatted in a special way. Mine just shows blank
cells.
Try
right clicking on a field>Field Settings>Layout & Print>remove check mark
from Show items with no data.

 

[sergio.siles]

Where you able to fix that thing Taveras? Im having the same problem
and I havent found a good solutions