To add a calculated field to a PivotTable,select a cell in the pivot table,then under the PivotTable Tools tab,click the Analyze tab.In the Calculations group,click Fields,Items,& Sets,and then click Calculated Field.Enter a name for the calculated field,type a formula in the Formula box,then click Add to save the calculated field,and click Close.

Question

Quizplus · Accepted Answer

This is the correct process to add a calculated field to a PivotTable.

To Add a Calculated Field to a PivotTable,select a Cell