MrExcel Publishing
Your One Stop for Excel Tips & Solutions

pivot table and weighted average


Posted by Carl Consalus on May 01, 2001 7:36 AM

Hoaw can you do a weightd average in a pivot table?


Posted by Mark W. on May 01, 2001 7:59 AM

Carl, add a 'Weighted_Value' field to your data
list that's defined as ='Weight'*'Value'. Next,
create a Calculated Field called 'Weighted_Average'
that's defined as ='Weighted_Value'/'Weight'.
Finally, use the Sum of 'Weighted_Average' in the
DATA area of your PivotTable.