Microsoft Office Tutorials and References
In Depth Information
Creating a Pivot Table
Pivot table calculations
Pivot table data is most frequently summarized by 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 in the Show Values As tab.
You have many options to choose from, including as a percentage of the total or subtotal.
Modifying the pivot table
After you create a pivot table, changing it is easy. For example, you can add further summary
information by using the PivotTable Field List. Figure 18-11 shows the pivot table after I dragged a
second field (OpenedBy) to the Row Labels section in the PivotTable Field List.
Following are some tips on other pivot table modifications that you can make:
h To remove a field from the pivot table, select it in the bottom part of the PivotTable Field
List and drag it away.
h If an area has more than one field, you can change the order in which the fields are listed
by dragging the field names. Doing so affects the appearance of the pivot table.
h To temporarily remove a field from the pivot table, remove the check mark from the field
name in the top part of the PivotTable Field List. The pivot table is redisplayed without that
field. Place the check mark back on the field name, and it appears in its previous section.