not displaying zeros in a pivottable
 

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 ToolsOptions
On the View tab, under 'Window options', remove the check mark
from 'Zero values'
Click OK

K. Gwynn wrote:
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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html