Forum Discussion
Excel 365 group pivot table
Hi there! I'm trying to find a way to group value in my Pivot table in Excel 365 Online but when I right click on the the cell I want to group I don't have the option, On the desktop application...
Afraid that doesn't work, Excel for web has limited functionality.
christonofr You could try a workaround. Add a column to the data where you can calculate the month from the date using something like CONCAT(TEXT(B2, "mmmm"), " ", TEXT(B2, "yyyy")) then use this column/field to group data in the Pivot table. Hope that helps.
