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 an...
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