how to insert a calculated item
Excel Pivot Table Calculated Field To add a calculated field: 1  Follow the steps above, to open the Calculated Field dialog box. 2  Type a name for the calculated field, for example, Bonus. 3  In the Formula box, type the IFformula that refers to the Units and Total fields: 4  Click Add to save the calculated field, then click Close.