Edit a calculated field
- Select the calculated field whose expression you want to edit.
- On the PivotTable list toolbar, click Commands and Options
, and then click the Calculation tab. - Edit the expression, and then click Change.
The data values will be automatically recalculated using the new expression.
TipTo add field references, select a field that you want to use from the Insert Reference to drop-down box, and then click the Insert Reference To button.