Pivot Table Data Crunching: Microsoft® Excel® 2010

5. Performing Calculations Within Pivot Tables

In This Chapter

Introducing Calculated Fields and Calculated Items 105

Creating Your First Calculated Field 109

Case Study: Summarizing Next Year’s Forecast 112

Creating Your First Calculated Item 116

Understanding Rules and Shortcomings of Pivot Table Calculations 120

Managing and Maintaining Your Pivot Table Calculations 124

Introducing Calculated Fields and Calculated Items

When analyzing data with pivot tables, you 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 your pivot table through calculated fields and calculated items.

A calculated field is a data field you create by ...