Beginning Pivot Tables in Excel 2007

CHAPTER 9Creating Calculationsin a Pivot Table

In this chapter, you'll see how easily you can get a different perspective on the data in your pivot tables. Instead of viewing total quantity sold or the average order price, you can change a setting in the pivot table to create any of the following custom calculations:

• Compare sales in one store to another.
• Calculate the difference in sales from one month to the next.
• Create a running total to see how sales accumulate over the year.
• See what percentage of a region's total sales comes from each product.
• Compare overall sales to each product's sales per region.

If none of these built-in calculations provides the perspective you need, you can create your own calculated fields and calculated items ...