Question: how to calculate weighted average in an excel pivot table?
Answer: Click the down arrow next to the word PivotTable at the left side of the PivotTable toolbar. ... 
Choose Formulas | Calculated Fields. ... 
In the Name box, enter a name for your new field.
In the Formula box, enter the formula you want used for your weighted average, such as =WeightedValue/Weight. ... 
Click OK.