With a calculated field, we can perform calculations on totals for other fields, such as multiplying a field's values by a percentage or dividing one field by another. A calculated field is a new field that can be used in the Values area.
We will create a calculated field in the BudgetTotal worksheet.
Step1. To select the BudgetTotal worksheet,
Click the BudgetTotal worksheet tab
Step2. To select a cell in the PivotTable, if necessary,
Click any cell in the PivotTable
Step3. Switch to the Analyze tab on the Ribbon,
Step4. To continue, in the Calculations group,
Click Calculated Field....
Step5. To replace the name, in the Name box, type:
Total Tab key
Step6. To remove the existing formula, press:
Step7. To create the formula, type:
Step8. To insert the formula in the PivotTable,
Step9. To rename the column header,
Click in cell E2, type: Total Expenditures
Step10. Expand the column width.
Step11. Save the worksheet.
NOTE: You cannot change column headings to match field names. For example, you cannot change the column heading from Sum of Total to Total because Total is already used as a field name.