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

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