Microsoft Office Tutorials and References
In Depth Information
One of the more useful features of a pivot table is the ability to combine items into groups. You can group items
that appear as Row Labels or Column Labels. Excel offers two ways to group items:
Manually: After creating the pivot table, select the items to be grouped and then choose PivotTable
Tools Options Group Group Selection. Or, you can right-click and choose Group from the shortcut
menu.
Automatically: If the items are numeric (or dates), use the Grouping dialog box to specify how you would
like to group the items. Select any item in the Row Labels or Column Labels and then choose PivotTable
Tools Options Group Group Selection. Or, you can right-click and choose Group from the shortcut
menu. In either case, Excel displays its Grouping dialog box.
If you create a pivot table using the Data Model, grouping is not an option.
A manual grouping example
Figure 18-21 shows a pivot table created from an employee list in columns A:C, which has the following fields:
Employee, Location, and Sex. The pivot table, in columns E:H, shows the number of employees in each of six
states, cross-tabulated by sex.
Search JabSto ::




Custom Search