When you clear a checkbox in a data field dropdown list, you're removing
the field from the pivot table layout. Just like a row field that was
removed, you have to drag it back to the pivot table layout, in order to
see it again.

Pam wrote:
I am working in Excel 2003. I have a bumch of expense catergories that I
would like to put into a pivot table. I also have a month and year column.
So I put my year in the column part of the Pivot Table Chart Wizard and my
month is the row part, and then all my expenses in the data portion. This
works to a point. As soon as I go to my Pivot Table and change my dad to
only view 1 or 2 expenses I lose the rest of the data. I have to go back in
and add the rest again. Why is it doing this?? Is there a better way??
What am I doing wrong?


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com