User Guide

271
Pivot Tables
Figure 11-7
Go to Layer Category dialog b ox
E Select a layer dimension in the Visible Category list. The Categories list will display
all categories for the selected dimension.
E Select the category you want in the Categories list and click OK. This changes the
layer and closes the dialog box.
To view another layer without closing the dialog box:
E Select the category and click Apply.
To Move Layers to Rows or Columns
If the table you are viewing is stacked in layers with only the top layer showing, you
can display all of the layers at once, either down the rows or across the columns.
There must be at least one icon in the Layer tray.
E From the Pivot menu choose Move Layers to Rows.
or
E From the Pivot menu choose Move Layers to Columns.