Question: how to calculate weighted average in pivot table in excel?
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.