User Guide

265
Pivot Tables
To Identify Pivot Table Dimensions
E Activate the pivot table.
E If pivoting trays are not on, from the Pivot Table menus choose:
Pivot
Pivoting Trays
E
Click and hold down the mouse button on an icon.
This highlig
hts the dimension labels in the pivot table.
To Transpose Rows and Columns
E From the Pivot Table menus choose:
Pivot
Transpose R
ows and Columns
This has the same effect as dragging all of the row icons into the Column tray and all
of the column icons into the Row tray.
To Change Display Order
The order of pivot icons in a dimension tray reflects the display order of elements in
the pivot table. To change the display order of elements in a dimension:
E Activate the pivot table.
E If pivoting trays are not already on, from the Pivot Table menus choose:
Pivot
Pivoting T
rays
E
Drag the i
cons in each tray to the order you want (left to right or top to bottom).
To Move Rows and Columns in a Pivot Table
E Activate the pivot table.
E Click the label for the row or column you want to move.