Data Analysis and Reporting with Intelligence Clients

Creating a Pivot Table

Pivot tables are made up of:

Facts – Core numeric data that you slice and dice dimensionally in your analysis.
Dimension (Legend Dimension) – Descriptive items that break aggregate data (facts) into logical categories. In the Pivot section, dimensions are either Top Labels or Side Labels.

For example, if you choose to analyze Unit Sales by region, the numbers are your data values or facts. Region is a dimension. Presented in aggregate, facts are subdivided by your chosen dimension labels.

To create a pivot table:

Choose InsertNew Pivot.
If the Outliner is not visible, click Outliner on the Section title bar.
Perform one of the following actions:
Drag each Request item to be included in the table from the Catalog pane to a pane in the Outliner (Top Labels, Side Labels, or Facts).
In the Catalog pane, select one of more Request items and choose PivotAdd Select ItemsOutliner Pane.

	Tip   Add Request items such as Unit Sales or Amount Sales to the Facts pane in Outliner to create the data grid. Add dimensions such as Product Line or Region to the Top and Side Labels panes in Outliner to create subdivisions.

	Tip   You can select and drag multiple items to the same Outliner pane to add multiple values or dimensional levels for analysis. Items are hierarchically ordered in the sequence in which they appear in the Outliner panes.