Chapter 30: Analyzing Data with PivotTables
3030
■ (^) To show percentages, add a second instance of the Location field to the Values sec-
tion. Then right-click a value in that column and choose Show Values As ➪ % of
Column Total.
■ Change the field names in the PivotTable to Ct and Pct by simply selecting those
cells and typing the new name.
■ Select a PivotTable style that makes it easier to distinguish the columns.
FIGURE 30.2
Changing the PivotTable to show counts and percentages
Grouping PivotTable Items
One of the most useful features of a PivotTable is the ability to combine items into groups.
You can group items that appear in the Rows or Columns section in the PivotTable Fields
task pane. Excel offers two ways to group items:
Manually After creating the PivotTable, select the items to be grouped and then choose
PivotTable Tools Analyze ➪ Group ➪ Group Selection, or you can select the items, 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 single item and then choose PivotTable
Tools Analyze ➪ Group ➪ Group Field, or right-click a single item and choose Group from
the shortcut menu. In either case, the Grouping dialog box appears. Use this dialog box to
specify how to group the items.
If you plan on creating multiple PivotTables that use different groupings, make sure you read the sidebar “Multiple
Groups from the Same Data Source.”
A manual grouping example
Figure 30.3 shows the PivotTable example from the previous sections, with two groups
created from the Row Labels. To create the first group, hold down the Ctrl key and select