Pivot Table Data Crunching for Microsoft® Office Excel® 2007

Chapter 5. Performing Calculations Within Your Pivot Tables

<feature><title>In This Chapter</title>

• Introducing Calculated Fields and Calculated Items 117

• Creating Your First Calculated Field 121

• Case Study: Summarizing Next Year’s Forecast 124

• Creating Your First Calculated Item 129

• Understanding Rules and Shortcomings of Pivot Table Calculations 133

• Managing and Maintaining Your Pivot Table Calculations 137

• Next Steps 140

</feature>

Introducing Calculated Fields and Calculated Items

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