J
jsmith
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
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