Microsoft Office Tutorials and References
In Depth Information
Grouping Pivot Table Items
Figure 18-20: A pivot table before creating groups of states.
To create the first group, I held the Ctrl key while I selected Arizona, California, and Washington.
Then I right-clicked and selected Group from the shortcut menu. I repeated the operation to
create the second group. Then I replaced the default group names (Group 1 and Group 2) with more
meaningful names (Eastern Region and Western Region). Figure 18-21 shows the result of the
Figure 18-21: A pivot table with two groups and subtotals for the groups.
You can create any number of groups and even create groups of groups.
The workbook used in this example is available on the companion CD-ROM. The file is
named employee list.xlsx .