Add a dimension to a pivot table

The dimension of a pivot table specifies the columns that the data is sorted by and the values against which aggregation occurs. Dimensions are represented by the Pivot Table Hierarchy Value.

When you add a Pivot Table, a single Pivot Table Hierarchy Value is added as a child. You can add more dimensions by dragging the Pivot Table Hierarchy Value object from the Tool Box and dropping it into the Pivot Table.
  1. In the Report Structure, select the Pivot Table Hierarchy Value.

    Figure: Hierarchy Value/Dimension in the Report Structure


    This figure shows an example of a Report Structure which points out the dimensions userid and orderid.

    You can now edit the Hierarchy Value properties in the Properties View.

  2. In the Value property, enter the column name for the dimension.
  3. If you want to use a Numeric dimension, select the Numeric Column check box. If this check box is not selected, the dimension is a String.
  4. Select the desired aggregation types, such as Compute Count or Compute Average. Compute Totals is selected by default.
  5. In the Title property, enter a title for the dimension.