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