Add a measure to a pivot table

A measure is used to aggregate numeric values in a pivot table.

About this task

In the Report Structure view, measures are placed under facts. When you add a Pivot Table, a single Pivot Table Fact and single Pivot Table Measure are added as children. You can add more Facts and Measures by dragging the objects from the Tool Box and dropping them into the Report Structure.

  1. In the Report Structure, select the Pivot Table Measure.

    Figure: Measures in the Report Structure


    This figure shows an example of a Report Structure which points out the measure unitprice.

    You can now edit the Measure properties in the Properties View.

  2. In the Value property, enter the column name for the measure.
  3. If you want to use a Numeric measure, select the Numeric Column check box and enter a value in the Format field. If this check box is not selected, the measure is a String and you do not need to specify a format.
  4. In the Title property, enter a title for the measure.