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.