In this lesson you will learn how to modify a calculated field in your pivot table. You need this to make proper calculation which you need at the moment.
Pivot table data preparation
1. Open sheet with your pivot table and click any cell in the pivot table to get it activated.
Adding a calculated field to pivot table
2. Go to Analyze tab. Select Fields, Items and Sets button and click Calculated Field.
3. A dialog box will appear. Enter the formula as per your requirements. (Marked with blue in the following screenshot):
4. Click ok. Excel will display the pivot table with an additional column (sum of discount in this case).
5. Click anywhere in the pivot table. PivotTable Fields appears on the right. Under sum of values, go to sum of quantity and click remove field.
Final result will be like this:
Modifying a calculated field in pivot table
As you see you have Sum of Discount instead of Sum of Quantity. Now you know how to modify calculated field in Pivot Tables. Use this to make your customized calculations.
Note: To delete a calculated field, select it in the "Insert Calculated Field" dialog box, and click the "Delete" button. To add a new calculated field, click the "New" button in the "Insert Calculated Field" dialog box.