Page 151 - Excel Data Analysis

08 537547 Ch07.qxd 3/4/03 12:07 PM Page 137

WORKING WITH PIVOTTABLE REPORTS 7

If you no longer want to include a calculated field in your If a calculated field does not return the
PivotTable report, you can delete it. To remove a calculated results you want, you can modify the
field, select the calculated field label on the PivotTable field. To modify it, click Insert ➪
report and then click Insert ➪ Calculated Field. In the Insert Calculated Field. In the Insert Calculated
Calculated Field dialog box, click the Name field and select Field dialog box, click the Name field
the name of the calculated field you want to remove. If the and select the name of the calculated
Name field contains the calculated field, click Delete. field you want to modify. Make the
appropriate changes in the Formula field
Keep in mind, if your PivotTable contains other calculated and click Modify.
fields that rely on the deleted field, your PivotTable may not
return the desired results. In fact, in most cases Excel
displays an error message, such as #NAME?, in the cells that
contain a formula that references the deleted calculated
field. See Appendix D for information on formula errors.

■ The new calculated field ■ Repeat steps 3 to 5 to ■ The new calculated field
displays in the Fields list box. create additional calculated displays in the PivotTable.
fields.
Á Click OK.

137