Hi Carlos,
Unfortunately this won't work for me. The check box is already cleared. My
scenario is that the pivot table is picking-up cells in the range that
contain only the formula...the result of the formula's calculation is
currently null. The pivot table IS showing zero but, I don't want to see it
at all in the pivot. Any other ideas?

"CarlosAntenna" wrote:

Right click on the field, choose field settings, clear the check box for
"Show items with no data".


"Greg Bobak" wrote in message
...
The set-up; (Example only....scenario is much larger) I have a pivot the
is
summing the voting results for the state of PA in in 3-categories,
appearing
in cells B1 through B3.
Cells A1 through A3 have the 3 categories Democratic, Republican
&Independant.
The problem: The Independant has a null values for its CALCULATED
results(the cell is blank). However, The pivot is showing the name
INDEPENDANT in the pivot.
How can I have the pivot not to show indenpendant without constantly using
the drop-down box to un-check the unwanted value. (again, my actual
scenrio
has over 500 constantly changing values. Let me know. Thanks!