Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365)

CHAPTER 5. Performing calculations in pivot tables

In this chapter, you will:

• Be introduced to calculated fields and calculated items

• Create a calculated field

• Create a calculated item

• Understand the rules and shortcomings of pivot table calculations

• Manage and maintain pivot table calculations

Introducing calculated fields and calculated items

When analyzing data with pivot tables, you will often need to expand your analysis to include data based on calculations that are not in your original data set. Excel provides a way to perform calculations within a pivot table through calculated fields, measures, and calculated items.

A calculated field is a data field you create by executing a calculation against existing fields in the pivot table. ...