Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Katie and Emil

We are Katie & Emil and together we have decided to learn more & more on how to build data warehouses using Microsoft products. The best option to learn is to teach so we write tutorials and share it with others.

PowerPivot default measure aggregation

One of the PowerPivot advantages is flexibility of changing measure aggregation for instance changing average to minimum. PowerPivot applies default aggregation to a measure and usually it is SUM but in our case SUM does not make any sense so in this tutorial I will show how to change default aggregation to an average and still have flexibility of changing in PivotTable to for instance minimum.

Comments

Leave a comment on the original post [www.katieandemil.com, opens in a new window]

Loading comments...