Pivot Table - Grouping dates using Report Filter

[swaza]

I have created my pivot table which includes all I need however I added a report filter which for me is 'Date Processed' and it lists every single date entered whereas I would like it to group them by month. I had formatted the cells in raw data to ensure it's a recognised date field.

I know you can group them if it's in Row Labels but can you do it within Report Filter???

[Bernie Deitrick]

One quick way is to include a column in your data source that just shows the month information as a string - use a formula like this for dates in column A

=TEXT(A2,"yyyy - mm (mmmm)")

Then copy down to match your table. - That will give you all the info you need to select the page filter.