Forum Discussion
Excel 365 (free web version) not grouping dates in pivot tables
I have a sheet with the following data; Date Salesperson Amount 4/4/2021 Ellie $727.00 6/11/2021 Izzy $426.00 4/12/2021 Frank $314.00 5/2/2021 Dara $228.00 7/28/2021 ...
At the moment, Excel for the Web doesn't support grouping in PivotTables.
It appears it is a feature the Excel team is considering:
Date grouping for PivotTables in Excel for the web · Community (microsoft.com)
Yeah, I suspected it was by design.
Thanks
Thanks