By default, reporting client tools such as PowerPivot apply the aggregate function Sum for column calculations when this ...

By default, reporting client tools such as PowerPivot apply the aggregate function Sum for column calculations when this column is added to a Field List area. To change the default calculation, select the appropriate function from the drop-down list. Example: Average.