Excel 2010 Bible

Chapter 34: Introducing Pivot Tables

707

Pivot table data is most frequently summarized using a sum. However, you can display your data using

a number of different summary techniques. Select any cell in the Values area of your pivot table and

then choose PivotTable Tools ➪ Options ➪ Active Field ➪ Field Settings to display the Value Field

Settings dialog box. This dialog box has two tabs: Summarize Values By and Show Values As.

Use the Summarize Values By tab to select a different summary function. Your choices are Sum, Count,

Average, Max, Min, Product, Count Numbers, StdDev, StdDevp, Var, and Varp.

To display your values in a different form, use the drop-down control on the Show Values As tab. You

have many options to choose from, including as a percentage of the total or subtotal.

Pivot Table Calculations

FIGURE 34.12

The pivot table is filtered by date.