Data Field Items deleted when unchecked in Pivot table
Hello,
I construct a pivot table. When I uncheck certain elements in the data field
drop down box, those items get deleted for ever. I have to go back to the
pivot chart wizard layout options to include them again.
However this is not observed in the case of row, column and page fields. I
have so many data items, and at time I would like to do analysis based on
only few elements and again i want all the elements back. This seems to be a
serious issue. Kindly help me.
--
Thanks
Anant
|