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?
Not sure about Mac, on Windows there is Excel setting
Thanks, this function does not exist for Mac or at least I cannot find it