Hiding 0 in Pivot Table

  • Thread starter Thread starter Bert
  • Start date Start date
B

Bert

I have a pivot table, how do I hide values of 0? I don't
want this data to show up in the pivot. Most of the data
is 0.

Thanks,
 
Doubleclick the grey column heading and uncheck "Show items with n
data"
 
You must log in or register to reply here.

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

Using VBA to create charts 1
Unable to Group in Pivot Table 1
How I can set dynamic pivot table ONLY when I have enough data point 1
Access #Error & Excel Pivot 0
Expand and collapse 2
How to add straight line from cell value in pivot table chart 1
Pivot table multiple filters 2
modified pivot table using a macro 2

Back
Top