User Guide

267
Pivot Tables
E
From the menus choose:
Edit
Ungroup
Ungrouping automatically deletes the group label.
To Rotate Pivot Table Labels
E Activate the pivot table.
E From the menus choose:
Format
Rotate InnerColumn Labels
or
Rotate OuterRow Labels
Figure 11-3
Rotated col
umn labels
363 76.6 76.6 76.6
27 5.7 5.7 82.3
84 17.7 17.7 100.0
474 100.0 100.0
Clerical
Custodial
Manager
To t a l
Frequency Percent
Valid
Percent
Cumulative
Percent
363 76.6 76.6 76.6
27 5.7 5.7 82.3
84 17.7 17.7 100.0
474 100.0 100.0
Clerical
Custodial
Manager
To t a l
Frequency
Percent
Valid Perc ent
Cumulative
Percent
Only the i
nnermost column labels and the outermost row labels can be rotated.
To Reset P ivots to Defaults
After performing one or more pivoting operations, you can return to the original
arrange
ment of the pivot table.