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.
