Data Analysis and Reporting with Intelligence Clients

Changing Label Nesting Levels

In pivot tables, labels from one dimension frequently are nested within another dimension. Nesting means that one set of labels appears as a subdivision of labels at a higher Level of data. You can change the way labels nest to emphasize different relationships.

For example, you can show Year and Quarter as data items in the Top Labels pane in Outliner. The Quarter labels (Q1, Q2, Q3, and Q4) are nested within each year label (1998, 1999). If you move Year after Quarter, then each year is displayed as a subset of each quarter. In this case, Q1 values are broken down by labels 1998, 1999.

To change the nested level of labels:

With more than one data item in an Outliner pane, select a data item in the Outliner.
Drag that item to the other side of the second data item in the same pane in Outliner.

The labels in those dimensions switch positions and the data is nested in a different manner.