Pivot Options Disappearing!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a pivot table which displays data for January Through December. I
ran a tesxt and deselected the "Show All" check box so that I can just
display Jan, Feb, and March data. When I go to reselect April - December data
those options are no longer available! How do I get excel to keep those items
on the list so that they can be selected later?
Thanks!
 
There's no Unhide option for the data fields. Once you uncheck a field,
it's removed from the pivot table. To see it again, you can drag the
field back in from the field list
 
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

Countifs or a pivot 1
pivot table 4
Variance Calculations 2
Display Pivot table summary in order of increasing time frame 4
Pivot table not recognizing same field values 1
Dependant Lists (Data Validation) 7
Pivot Table Grouping by Quarters 3
Pivot Table Duplicate January 2

Back
Top