A weighted average is an average that takes into account the importance, or weight, of each value. When you calculate a weighted average, you assign a weight to each value, then calculate the sum of the weighted values divided by the sum of the weights. This type of average is often used when you have data that represents a population with different levels of importance.
In a PivotTable, you can calculate a weighted average for numeric fields by adding a calculated field. A calculated field is a column that you add to a PivotTable that contains a formula. The formula can use the fields in the PivotTable as well as other mathematical operators.
To add a calculated field:
span > div >< p align = "left" > 5 . To see how your formula works , click < b > Add b > to add the field to your PivotTable , then drag it next to the field on which it's based . You can also click < b > OK b > without adding the field to see how it would affect your results . If you're satisfied with your results , click < b > OK b > again . Otherwise , make changes to your formula and repeat steps 3 - 5 until you get the results you want . p >< p align = "left" >< o : p >& nbsp ; o : p > p