Pivot Table: Month Filter

[mouse88]

I have a pivot table and I am using the date field from my main table as a filter.

I need to be able to look at data for a particular month or week.

I can do it it by manually ticking the individual days in the filter drop down but by the time I get records for all 365 days of the year this will be a nightmare.

Is there anyway I can get an option in the filter drop down to view certain weeks or months?

Thanks

Matt


Pivot Table:

Filter Drop Down:

 

[mouse88]

Anyone?