Excel 2007 PivotTables Recipes: A Problem-Solution Approach

CHAPTER 3Calculations in a Pivot Table

In a pivot table, you can use functions like Sum, Count, or Average to summarize the fields you place in the Values area. You can also use custom calculations, such as Difference From, and Running Total, to show a different perspective on the data. For even greater flexibility, you can write your own formulas to create calculated fields and calculated items in the pivot table.

3.1. Using Summary Functions: Defaulting to Sum or Count

Problem

The sales manager sent you a workbook with sales data, and she asked you to create a pivot table from the data. You added the Product field to the Row Labels area, the District field to the Report Filter area, and Units and TotalSales to the Values area.

When you added ...