How to Add Calculated Field in Pivot Table?

Select any cell inside the PivotTable

Go to the PivotTable Analyze or Options tab

Click Fields, Items, & Sets

Choose Calculated Field

Enter a name for the calculated field

Enter the formula using PivotTable field names

Click Add or OK

Click OK to insert the calculated field

Refresh the PivotTable if needed

Use the new calculated field in the Values area

Suggested for You

Trending Today