Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
I don't think that is possible
Pivot Table - Edit Groupings
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
I am using the Group Function in a Pivot Table. Basically I have Payroll Job Codes and I group like codes together and rename accordingly.
IE Job Codes 1, 3, 51, and 53 (Group 1) are similiar as are 2, 4, 52, and 54 (Group 2). New codes are added on a regular basis and I want to be able to add that code to the respective Group without having to Ungroup and regroup or by creating another layer by Grouping say Group 1 with the new code 61.
Microsoft 365 and Office | Excel | For home | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Answer accepted by question author
Ashish Mathur
101.9K
Reputation points
Volunteer Moderator
Hi,
Grouping will not auto update. You will have to create a spare column in your source data (which will return Groups, say Group 1, Group 2 etc) and then drag this spare column in the pivot table.
1 additional answer
Sort by: Most helpful
-
Anonymous
2012-04-01T00:10:22+00:00 Can I edit the codes that are in the grouping so how, or do I just have to hit ungroup, and then reselect all the ones I had plus the new one.