Specifying Alternative Aggregation Methods for a Measure

Specifying Alternative Aggregation Methods for a Measure

For any cell in a pivot table, each measure is aggregated from the lowest-level data. Aggregation methods include sum, average, maximum value, and others. By default, the system uses the aggregation method specified in the measure definition. You can specify an alternative method.

Similarly, if you add a summary row or column, you specify how to aggregate the displayed values into a single number for that summary row or column. You can specify an alternative method for this as well.

To specify alternative aggregation methods for a measure:

1. Click the Advanced Options button next to the measure.

   See Customizing Pivot Table Items.

2. Specify either or both of the following options:

   • Measure Aggregate specifies how this measure is aggregated from a set of values in your data.

     The choices are SUM, AVG, MIN, MAX, and COUNT.

   • Total Override specifies how the displayed measure values are aggregated for any summary rows or columns.

     The choices are Sum, Count, Min, Max, Average, % of Total, and None.

3. Click OK.

See also Adding a Summary Row or Column.