Pivor Table Data Field - "Show aftering Hide"

D

~Dave

I have tried to "show" a data field after using "hide" in field settings. How can I make this reappear? Not using Field drop down option. The fields orgin is from the excel list and not a calculated fields.
 
D

Debra Dalgleish

If you deselect an item in the Data dropdown, it's removed from the
pivot table, and from the Data dropdown list. To see it in the chart
again, you can drag it back from the Pivot Table Field List.
 
Top