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.