What is a calculated field in a Pivot Table?

A calculated field is a custom value field that uses a formula based on fields in the Pivot Table source data.

When should I avoid calculated fields?

Avoid calculated fields for complex row-level logic, weighted averages, and calculations that are clearer in the source table or Power Pivot.

What should I practice after reading this tutorial?

Rebuild the main example on a copy of your file, then change one argument at a time to see how the result changes. That builds muscle memory faster than rereading the steps.

Which Excel version do I need for the formulas in this article?

Most steps work in Excel 2016 and later. If the article mentions FILTER, UNIQUE, or XLOOKUP, you need Microsoft 365 or Excel 2021 — check the linked function pages for compatibility.

Why does my Pivot Table show wrong totals?

Refresh the pivot, confirm the source includes new rows (use an Excel Table), and check that numbers are not stored as text.

Tutorials - 2026-05-12

Pivot Table Calculated Field in Excel

Learn how to add a calculated field to an Excel Pivot Table, when to use it, common limitations, and better alternatives for complex analysis.

What a Calculated Field Does

A Pivot Table calculated field creates a new value field using a formula based on other fields in the source data. It is useful for quick metrics like profit, margin, or variance. Example use cases: Profit = Revenue - Cost Margin = Profit / Revenue Variance = Actual - Budget

Add a Calculated Field

Click inside the Pivot Table, then use: PivotTable Analyze -> Fields, Items & Sets -> Calculated Field Enter a name and formula, such as: \\\ =Revenue-Cost \\\ Excel adds the calculated field to the Values area.

Calculated Field Limitations

Calculated fields work on summarized data, not individual row-level logic in the same way normal formulas do. They can be confusing when formulas depend on averages, percentages, or weighted calculations. For complex analysis, add the calculation to the source table before creating the Pivot Table.

Better Alternatives

Use a source-table formula when the metric must be calculated row by row. Use Power Pivot measures when you need more advanced business logic.

Related Guides

Excel Pivot Tables Beginners Guide Excel Percentage Formula SUMIFS function

Apply this tutorial in your workbook

Copy one example from this article into a blank sheet. Change the sample ranges to match your column letters. Press F2 and Enter after edits so Excel recalculates. Compare your result to the expected output in the article. Related hubs: Excel functions directory · Formula guides · Function comparisons \nPivot help: Pivot tables guide · Pivot not updating · Pivot mistakes

Frequently asked questions

What is a calculated field in a Pivot Table? A calculated field is a custom value field that uses a formula based on fields in the Pivot Table source data.
When should I avoid calculated fields? Avoid calculated fields for complex row-level logic, weighted averages, and calculations that are clearer in the source table or Power Pivot.
What should I practice after reading this tutorial? Rebuild the main example on a copy of your file, then change one argument at a time to see how the result changes. That builds muscle memory faster than rereading the steps.
Which Excel version do I need for the formulas in this article? Most steps work in Excel 2016 and later. If the article mentions FILTER, UNIQUE, or XLOOKUP, you need Microsoft 365 or Excel 2021 — check the linked function pages for compatibility.
Why does my Pivot Table show wrong totals? Refresh the pivot, confirm the source includes new rows (use an Excel Table), and check that numbers are not stored as text.