Microsoft Office Tutorials and References
In Depth Information
The PivotTable Tools ⇒ Analyze ⇒ Show group contains additional options that affect the appearance of your
pivot table. For example, you use the Field Headers button to toggle the display of the field headings.
Still more pivot table options are available in the PivotTable Options dialog box, shown in Figure 18-11. To dis-
play this dialog box, choose PivotTable Tools ⇒ Analyze ⇒ PivotTable ⇒ Options. Or, right-click any cell in the
pivot table and choose PivotTable Options from the shortcut menu.
The best way to become familiar with all of these layout and formatting options is to experiment.
Figure 18-11: The PivotTable Options dialog box.
Pivot table calculations
Pivot table data is most frequently summarized using a sum. However, you can display your data using a number
of different summary techniques, specified in the Value Field Settings dialog box. The quickest way to display this
dialog box is to right-click any value in the pivot table and choose Value Field Settings from the shortcut menu.
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.