Edit a calculated field

Office PivotTable

previous page next page

In the design window, make sure the PivotTable list is activated. For instructions, see Help for your design program.

Select the calculated field whose expression you want to edit.

On the 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