filtering dates in a Pivot Table Report Filter

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
 
J

jsmith

Update: Even if I use the filter in the field list it is not actually
fitlering the data. It looks like it is but is not.
 
G

GaiGauci

Hi I don't know if I actually understood your problem so this might not be
relevant. I have a group of pivot tables and I put a column to the right of
the (in my case) downloaded data. The column shows the month/year only and so
I select only the months I want to look at. so I do =
DATE(YEAR(O2),MONTH(O2),31) in the inserted column. I'm sure there is a
cleverer way...

Cheers
Gai
 

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

Top