Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
Pivot Table - Filter | Excel Discussion (Misc queries) | |||
Pivot Table vs Filter | Excel Discussion (Misc queries) |