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 I can find it but not on the online application. (sorry for the screen shot in french 😉 )
Does anyone know where I can find this option ?
Thanks a lot,
Chris
Afraid that doesn't work, Excel for web has limited functionality.
Afraid that doesn't work, Excel for web has limited functionality.
- Thanks a lot for the quick answer! I'll go on the desktop version then 😊
Yes, if you have desktop version it's better to use it. Online version in many cases works with files created in desktop version, but doesn't allow to edit/add some features.
- Would be nice to vote for this to be included in web app, its painful that I just want to do something basic in a pivot table on webapp whislt my desktop version is tied up refreshing a query on another workbook. Might go looking for that user request hub.
Excel for the web is improving, new functionality appears practically every month. Of course, depends on your subscription. If something is missed you may add your vote for the current suggestion or add new one her Excel · Community (microsoft.com)
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.
