Office 365 Pivot Table Report Filter - Group Dates

[jim may]

I've created a Pivot Table and have added 2 Fields as Report Filters; One a Text Label the Other a Date field.
How can I Group (in this Filter area) my dates By Month?

 

[steve the fish]

You cant as far as im aware. You can workaround by using the columns area then just showing your month or by adding a column in the source data.

 

[SpillerBD]

Initially you only have the date. Once you drop a Date Field into the ROW, Excel assumes you want the grouping and creates Quarters and Months. Those will now be new fields in the Fields list.
You could then move the Months field to the Filter area.

 

[jim may]

Thanks guys.. I'll give it a go...

 

[jim may]

Hey Guys -- Just came across this web-page -- Copied Code submitted by abz into my Sheet -- WORKS PERFECTLY!!! Jim

https://stackoverflow.com/questions/44114582/vba-to-select-specified-date-range-in-pivot-table-filter