O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

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

Changing a PivotTable's Calculations

By default, Excel populates the data area of your PivotTable by applying the Sum function to any numeric field you put in the data area or the Count function to any nonnumeric field. But you can choose from many alternative forms of calculation, and you can add your own calculated fields to the table.

Using a Different Summary Function

To switch to a different summary function, select any cell in the data area of your PivotTable. Then click the Field Settings button on the PivotTable toolbar (or choose PivotTable, Field Settings). Excel displays the PivotTable Field dialog box (refer to Figure 30-12). Select the function you want to use, and then click OK.

Applying Multiple Summary Functions to the Same Field ...

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