Page 144 - Excel Data Analysis
P. 144

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







                     EXCEL DATA ANALYSIS


                  CHANGE THE CALCULATION

                  OF A DATA FIELD




                          hen you create a PivotTable report, Excel   When you change the function, the Data area reflects the
                          performs Standard calculations by summarizing  selection. For example, if the selected function is Count and
                  W the data values that appear in the Data area. For  the field in the Data area is Amount, the name of the Data
                  example, if the cell contains all sales in Arkansas during  area becomes Count of Amount.
                  January, Excel determines the cell value by summing all of  You can also customize the selected function by adding
                  the matching sales totals from the original data. If you have  some calculation options available on the PivotTable field
                  sales from four different sales people, Excel totals all four  dialog box. For example, you can determine what
                  amounts and places them in the cell.
                                                                      percentage a sum is of a total amount by combining the
                  You can change your data's summary to something other  Sum function with the % of calculation option.
                  than the default Sum function. Excel lets you select from  Some of the custom calculations options require more
                  eleven different functions to summarize the original data  information about the calculation. You must define the field
                  values, such as counting the values or finding the maximum  that you want to use for the calculation as well as the value
                  value. For example, if you selected the Count function, each  for the field. For example, to determine the difference
                  cell contains a number representing the number of values  between the current month and the previous month sales,
                  in the original data. If you had four sales amounts for  you select the Month field and Previous in the Base item box.
                  Arkansas, the cell contains the number 4 and not the total
                  amount.
                   CHANGE THE CALCULATION OF A DATA FIELD








                                                                                 Sum of Amount
                                                                              Sum














                  ⁄ Right-click on the Data   ■ A menu of options    ■ The PivotTable Field dialog   ‹ Click a new summary
                  field.                    displays.                box displays.             function.
                                            ¤ Click Field Settings.                            › Click Options.





                   130
   139   140   141   142   143   144   145   146   147   148   149