ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   pivot table filter (https://www.excelbanter.com/excel-discussion-misc-queries/161414-pivot-table-filter.html)

scubadiver

pivot table filter
 

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?

scubadiver

pivot table filter
 

Problem solved.

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


"scubadiver" wrote:


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?



All times are GMT +1. The time now is 02:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com