

# Adding and deleting pivot table calculations


Use the following procedures to add, modify, and remove table calculation on a pivot table.

**Topics**
+ [

# Adding a pivot table calculation
](add-a-calculation.md)
+ [

# Changing how a calculation is applied
](change-how-a-calculation-is-applied.md)
+ [

# Removing a calculation
](remove-a-calculation.md)

# Adding a pivot table calculation


Use the following procedure to add a table calculation to a pivot table.

**To add a table calculation to a pivot table**

1. Expand the **Field wells** pane by choosing the field wells near the bottom of the visual.

1. Choose the field in the **Values** well that you want to apply a table calculation to, choose **Add table calculation**, and then choose the function to apply.

**Note**  
You can't run Total, Difference, and Percent Difference table calculations when a pivot table is being sorted by a measure. To use these table calculations, remove the sort from the pivot table.

# Changing how a calculation is applied


Use the following procedure to change the way a table calculation is applied to a pivot table.

**To change the way a table calculation is applied to a pivot table**

1. Expand the **Field wells** pane by choosing field wells at the top of the visual.

1. Choose the field in the **Values** well that has the table calculation that you want to change, choose **Calculate as**, and then choose the way that you want the calculation applied.

# Removing a calculation


Use the following procedure to remove a table calculation from a pivot table.

**To remove a table calculation from a pivot table**

1. Expand the **Field wells** pane by choosing the field wells near the bottom of the visual.

1. Choose the field in the **Values** well that you want to remove the table calculation from, and then choose **Remove**.