Pivot Table Grouping

[jezmechanic]

Hi All

I feel this is probably something very easy that I am missing. When I create a pivot table with my data I cant seem to group any of the data columns. As a result,if I want to show the complaints that were upheld in March 2019 I have to look in the filter and manually select each day in March. Help!!!!

I cant seem to attach my data so any help would be appreciated.

Thank you!!

 

[NZWestCoast]

Hi All

I feel this is probably something very easy that I am missing. When I create a pivot table with my data I cant seem to group any of the data columns. As a result,if I want to show the complaints that were upheld in March 2019 I have to look in the filter and manually select each day in March. Help!!!!

I cant seem to attach my data so any help would be appreciated.

Thank you!!

Hi did you figure this out?
I have a pivot table with Date as the filter and I need to filter the data by removing particular years, but the filter list in NOT grouping. Grouping is set up in the Advanced settings and the source data has been formatted correctly. I have been unable to find a solution to this one online (specifically for the filtering date grouping)