Edit a calculated field

  1. In the design window, make sure the PivotTable list is activated. For instructions, see Help for your design program.
  2. Select the calculated field whose expression you want to edit.
  3. On the toolbar, click Commands and Options , 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 drop-down box, and then click the Insert Reference To button.