Calculating A Weighted Average In a Pivot Table

Ah, we are talking about different weighted averages. I actually opened your workbook this time

Originally Posted by Mvaldesi

so the subtotal average is skewed

Subtotal averages in pivot tables are already weighted.

Another way of showing how much a shipper contributes to total duration is to show sum duration as % of grand total.


See attached workbook.

Originally Posted by Stormin'

Subtotal averages in pivot tables are already weighted.

Well, hell, I see that now! Thanks for your help!