Edit a calculated field

Office PivotTable Lists

previous page next page

Select the calculated field whose expression you want to edit.

On the PivotTable list toolbar, click Commands and Options Button image

, and then click the Calculation tab.

Edit the expression, and then click Change.

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

Show 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.

previous page start next page