How to Add Calculated Fields to Pivot Tables in Excel 2013
1 of 5
Click any of the cells in the pivot table and then select the Calculated Field option from the Fields, Items, & Sets button’s drop-down list, or press Alt+JTJF.
The Fields, Items, & Sets command button is found in the Calculations group on Analyze tab on the PivotTable Tools contextual tab.
Excel opens the Insert Calculated Field dialog box.