Page 148 - Excel Data Analysis

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

EXCEL DATA ANALYSIS

ADD ANOTHER DATA AREA CALCULATION

f you want to show multiple calculations in the Data Each field in the Data area uses some type of summary
area, you can do so by adding additional fields. Perhaps calculation to display the results. The default summary
I you want to analyze the sales figures by showing both calculation is the Sum function. You can change the
the amount of the sales and the percentage of sales each summary function to any of the functions available on the
sale represents. You can either add a different field to the PivotTable Field dialog box. You can also create custom
Data area, or you can add another copy of the same field summary calculations. See the section "Change the
and apply a different summary calculation. Calculation of a Data Field" for more information on
customizing a Data field calculation.
Excel automatically names each Data area field based upon
the name of the field and the calculation that the field uses. You can change the summarization calculation for each data
For example, if your Data area field name is Amount; the field. For example, you can have the first item sum the
first instance of the field is named Sum of Amount; if you amounts and the second item determine the percentage of
add another instance of the same field, Excel names the the amount in relation to the other sums in the column. See
second field Sum of Amount2. The field name is important the section "Change the Calculation of a Data Field" for
because it provides the description necessary to interpret more information.
the PivotTable results. Therefore, you should adjust the field
names on the PivotTable Field dialog box to reflect
information you want to convey in your analysis.
ADD ANOTHER DATA AREA CALCULATION

Amount

⁄ In the PivotTable Field ¤ Drag the field selection ■ The selected field displays ‹ Right click the new Data
List, select the field to add. to the Data area of the as the second row in the Data field and click Field Settings
PivotTable Report and area. from the options that display.
■ You can click the Show release the mouse button.
Field List button to display
the PivotTable Field List.

134