Edit a calculated field

  1. Select the calculated field whose expression you want to edit.
  2. On the PivotTable list toolbar, click Commands and Options , and then click the Calculation tab.
  3. 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 drop-down box, and then click the Insert Reference To button.