Edit a calculated field in PivotTable view

1. Open a datasheet or form in PivotTable view.
2. Select the calculated field whose expression you want to edit.
3. On the PivotTable toolbar, click Properties , and then click the Calculation tab.
4. Edit the expression, and then click Change.

   The data values will be automatically recalculated using the new expression.

Tip

To add field references, select a field that you want to use from the Insert Reference To box, and then click the Insert Reference To button.