Pivor Table Data Field - "Show aftering Hide"

  • Thread starter Thread starter ~Dave
  • Start date Start date
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.
 
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.
 
Thanks Debra it works...

Dave

Pittsburgh PA
Debra Dalgleish said:
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.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to preserve column fields in a specific order in a pivot table? 2
Field list not showing up 7
How to subtract a number from a Mergefield? 0
Windows XP Show Field List in Pivot Table 1
Calculated Field in a Pivottable 2
Turning Data into a Table 1
Trying to add Long Integer field 1
pivot table calculated field 1

Back
Top