Lesson 2**Lesson learned**

Average of averages is not the average of initial values

Be careful with aggregating of aggregated. Sum of sum is sum of initial values, but not the average of averages.**Why**

As groups have different sizes, if you do average their averages you calculate them equal-weighted, ignore their size.**How to**

Calculate overall quality/ average as you calculate it for each individual grooup and not averge the averages!

You can use calculated field in pivot (Sum/ Num) to calculate the average or ( sum of good/ total sum ) to quality.

Using the type of calculation-average in pivot will be mistake ...**How I learned**

Again, angry calls. :) .

We have to calculate quality parameters for each department and to each district. And again the average quality of district is not the average of quality of its departments. As they are not equall....