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.
In the Report Structure,
select the Pivot Table Hierarchy Value.
You can now edit the Hierarchy Value properties in the Properties View.
In the Value property,
enter the column name for the dimension.
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.