You need to add a calculated field to the report.

1.Click the report.

2.On the PivotTable toolbar, click PivotTable, point to Formulas, and then
click Calculated Field.

3.In the Name box, type a name for the field.

4.In the Formula box, enter the formula for the field.
To use the data from another field in the formula, click the field in the
Fields box, and then click Insert Field. For example, to calculate a weighted
average, you could enter = [Variable 1] * [Weight Variable].

5.Click Add, and then click OK.


"nasser" wrote:

Can I get the weighted average in pivot table?