Aggregation

You can also specify a default aggregation for any measure. The default aggregation will be used automatically when the measure is first totaled in the view.

1. Right-click any measure in the Data window and select Default Properties > Aggregation.
   
2. On the Aggregation list, select an aggregation.
   
   Whether you are specifying the aggregation for a field on a shelf or the default aggregation in the Data window, you can select from several aggregations. See Aggregations to learn about each type of aggregation.