Excel 2007 Pivot Tables - do not display zero values

  • Thread starter Thread starter Barb Reinhardt
  • Start date Start date
B

Barb Reinhardt

How do I set my pivot table so that it does not display any sums of values
that are equal to zero?

Thanks,

Barb Reinhardt
 
You can use conditional formatting to set the foreground colour to
white if the cell contents are zero.

Hope this helps.

Pete
 
Change the number format to suppress them using, for example:

General;General;;@

as a custom format.

Hope this helps
Adam
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Page Field Issue (Not sorting) 2
PIVOT Display is WRONG 3
Pivot table assistance 1
Pivot Table Shows Only Zeros 3
Rows not being displayed 1
Hiding Zero Values in a Pivot Table - MS Excel 2007 4
Pivot Table exclude negative values from sum 2
Pivot table filter list - listing irrelevant subcategorys 1

Back
Top