Subscribe to this blog
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
Briefcase
Print
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...