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 ...

Get Beginning Pivot Tables in Excel 2007 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.