9.2.4.Modify a PivotTable Report |
|
Click any field in the PivotTable report.
Click the Options tab under PivotTable Tools.
|
|
![Click any field in the PivotTable report. Click the Options tab under PivotTable Tools.](../../Microsoft-Office-Excel-2007Images/Modify_Pivottable_Report___Click_Any_Field_In_Pivottable_Repor.PNG) |
To change PivotTable options, click the Options button
|
|
![To change PivotTable options, click the Options button](../../Microsoft-Office-Excel-2007Images/Modify_Pivottable_Report___To_Change_Pivottable_Options_Click_.PNG) |
Make the changes and then click OK.
|
|
![Make the changes and then click OK.](../../Microsoft-Office-Excel-2007Images/Modify_Pivottable_Report___Make_Changes_And_Then_Click_Ok.PNG) |
To change field settings, select the field,
click the Field Settings button
|
|
![To change field settings, select the field, click the Field Settings button](../../Microsoft-Office-Excel-2007Images/Modify_Pivottable_Report___To_Change_Field_Settings_Select_Fie.PNG) |
Then Make the changes and then click OK.
|
|
![Then Make the changes and then click OK.](../../Microsoft-Office-Excel-2007Images/Modify_Pivottable_Report___Then_Make_Changes_And_Then_Click_Ok.PNG) |