Pivottables

E

Ed

My PivotTable has 8 fields in the data area. They are yearly totals and
%'ages. If I deselect a field in the Data drop-down, it disappears from the
list and cannot reselect it again. I need to re-add the field back to the
data area. I would like my users to be able to select/deselect from the data
list so they can look at one year's totals or all the years' totals. I
noticed if I deselect one of the entries in my rows or columns sections, the
field remains, but unchecked. Is there anyway to do it with the data field?
 
D

Debra Dalgleish

If you uncheck an item in the data dropdown list, it's removed from the
pivot table. There's no way to retain it in the data field list.

To get it back, you can drag it in from the field list.
 
Top