Forum Discussion
group in pivot table
Hello everybody,
I am working on the web version of excel for school. And I need to use the web version and not the normal one because of the fact I have a chromebook but my question is. Does anyone know how you can make groups in pivot tables on the excel webversion?
3 Replies
You're welcome NielsWiegman
And next time someone will have the same question we'll re-invent the wheel due to no feedback from your end (Thank you)
No idea what Grouping you expect to do, so example only where in the Pivot Data Source we have [Account]s we want to group, same goes for [Date] to be grouped by Year & Month. Next to the actual data, 3 calculated Helper Columns (can be hidden of course):
PivotTable:
Corresponding sample available https://1drv.ms/x/s!AsuqEFbTJNgcgacAxdx48Zund_MTrg?e=xOf4Ex. You'll see a HELPER_SHEET with a table where [Account]s are "classified": 0-999; 1000-1999; 2000-2999...
Hope this helps
Hi NielsWiegman
To my knowledge Excel Web doesn't - currently - support Grouping in PivotTables
Quickly search this site and found Excel 365 (free web version) not grouping dates in pivot tables where a key that says the same
I would suggest you UpVote https://feedbackportal.microsoft.com/feedback/idea/8a27812c-0492-ed11-aad1-000d3a1f4ab5 in the meantime
