Excel PivotTablesLesson 68Free preview

Excel Calculated Field

This lesson is part of Excel · All levels

Summary

Calculated Fields add virtual columns to the PivotTable that are calculated from other fields with a formula, for example, Profit = Revenue - Cost. This new field does not change the source data, only appears as an additional field to the report. The formula uses the field name as a variable, not a normal cell address.

Key points

Calculated Field is a derived field with a custom formula
It is in PivotTable Analysis > Fields, Items & Sets > Calculated Field
The formula uses the field name, for example = Revenue - Cost
The source data is not changed at all

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.