- The Need to Customize
- Displaying the PivotTable Field Dialog Box
- Customizing Field Names
- Applying Numeric Formats to Data Fields
- Changing Summary Calculations
- Adding and Removing Subtotals
- Using Running Total Options
- Next Steps
This chapter is from the book
This chapter is from the book
This chapter is from the book
Displaying the PivotTable Field Dialog Box
Each row field, column field, and data field has its own PivotTable Field dialog box. The easiest way to activate the dialog box is to double-click on the field name in the pivot table.
The PivotTable Field dialog box has three versions. If you display the dialog box for a field in the row or column area of a pivot table, you will see the dialog box shown in Figure 3.1.
)
Figure 3.1 The PivotTable Field dialog box for a row or column field allows you to control the subtotals and field name.
The PivotTable Field dialog box for a field in the PageField area of a pivot table includes options for hiding certain items, as shown in Figure 3.2.
)
Figure 3.2 Fields in the PageField section have additional options to hide items.
The PivotTable Field dialog box used for fields in the data area of the pivot table has an Options button. Choose that button to access the running total options for the field. Figure 3.3 shows the dialog box after choosing the Options button.
)
Figure 3.3 The dialog box to customize fields in the data section of the pivot table includes the running total options. To access the lower third of the dialog box, click the Options button.