pivot table filter

G

Guest

I have a problem with this.

I have a list of records for which the dates are either "Aug 07", "Sept 07"
or "Oct 07".

In the pivot table field list dialogue box, all three months appear. In the
pivot table field filter (the drop down box where you tick what you want to
view) "Sept 07" doesn't appear.

Any ideas?
 
G

Guest

Problem solved.

It is possible to hide and unhide what is shown in the dialogue box.
 

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

Possible 'calculated field' to total selected pivot table data ite 2
Pivot table 3
Sort pivot table field (droplist) by month or original data 1
Pivot table wizards 2
date filter in a pivot table 1
Grouping dates in pivot table 3
Pivot Table - month groups 2
Top X% in Pivot Tables 1

Top