not displaying zeros in a pivottable

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've just build a pivot table form a data set that I expect to be changing
over time. Right now, however, I've got a lot of 0% in the pivot table, and
its making it really hard to find the places where there are actual percents
values. Is there any way to supress the zero values? I can't seem to get it
to work with the "for empty cells option" in the Table Options. And since I'm
going to be adding informaiton to my data set, I don't want to continually
include/exclude data to my pivot table.
 
You can hide zero values on the worksheet:

Choose Tools>Options
On the View tab, under 'Window options', remove the check mark
from 'Zero values'
Click OK
 
Back
Top