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

Get Excel Pivot Tables Recipe Book: A Problem-Solution Approach 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.