Pivot Table group dates

Copper Contributor

My challenge has been the automatic grouping of dates in Pivot tables. I want dates to be grouped automatically and it works with the same data in the filter function but it does not work in the pivot table. Anyone had that problem?

2 Replies

Not sure about Mac, on Windows there is Excel setting

image.png

 

Thanks, this function does not exist for Mac or at least I cannot find it