O'Reilly logo

Excel Pivot Tables Recipe Book: A Problem-Solution Approach by Debra Dalgleish

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 3Calculations in a Pivot Table

In a pivot table, you can use summary functions or custom calculations to summarize the data, and you can write your own formulas to create calculated fields and calculated items.

3.1. Using Summary Functions

Problem

You can select from a list of summary functions when subtotaling fields in a pivot table or adding fields to the data area, and you wonder if they're the same as the worksheet functions.

Solution

When you add a field to the pivot table, a list of 11 functions is available to summarize the data in the data area or subtotal the data for row and column fields. The summary functions in a pivot table are similar to the worksheet functions with the same names, with a few differences as noted in the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required