Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
filtering dates in a Pivot Table Report Filter
Hi,
I have a file with over 25k rows and 100 columns. I also have 15 various pivot tables. In about 6 of these tables I need to filter a date range. The trick here is that the date is not part of the Column or Row labels. The date filed is only one of the Report Filters. I need to be able to filter out dates in the last six months. I can deselect these dates manually but that means deselcting almost 180 dates across 6 pivots (a total of 1080 deselects!) If I move the date field to a column or row label I get the fly-out option to filter a date range, but as a report filter I do not get this option. Any suggestions? Thanks - Jeannell |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PIVOT - Reference a cell outside the table for report filtering | Excel Discussion (Misc queries) | |||
Pivot Table Report Filter Sorting | Excel Discussion (Misc queries) | |||
how do i elmininate old data from Report filter on pivot table? | Excel Discussion (Misc queries) | |||
Pivot Table filtering dates | Excel Discussion (Misc queries) | |||
Pivot table report filter problem | Excel Discussion (Misc queries) |