Dates in filter dropdowns

[pholt33]

I have a data set with filters that groups dates by year, month, and then the actual date. When I create a pivot table the filter option is every individual date. I thought there was a way for the pivot dropdown to do the same year/mo grouping. What am I missing?

source data

Pivot table filter setup

Then within the filter

 

[jasonb75]

If you have dates as pivot row labels then you have a bit more flexibility, but a pivot filter only appears to use exact field contents.

How to Use Excel Pivot Table Date Range Filter- Steps, Video

Use Excel Pivot Table Filters for selected dates, date range, dynamic dates like last week. Stop date grouping in drop down. Easy steps, video, Excel file

www.contextures.com