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 technique of double-clicking the field name will work for page, column, and row fields. It will work for data fields only if the pivot table contains just one data field. If your pivot table contains two or more data fields, you need to right-click on the data field name and choose Field Settings.

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.


You can also activate the PivotTable Field dialog box of a particular field by right-clicking on the field you are customizing and selecting Field Settings.

    Pivot Table Data Crunching
    Pivot Table Data Crunching for Microsoft Office Excel 2007
    ISBN: 0789736012
    EAN: 2147483647
    Year: 2003
    Pages: 140

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net