Microsoft Office Tutorials and References
In Depth Information
BUILT-IN FUNCTIONS
4. Next, drag the Product field to the Drop Row Fields Here area. You should see the result shown
in Figure E-16.
FIGURE E-16
Row fields
5. Finally, drag the month fields (January, February, and March) individually to the Drop Value
Fields Here area to produce the finalized pivot table. You should see the result shown in
Figure E-17.
FIGURE E-17
Data items
By default, Excel adds all of the sales for each salesperson by month for each product. At the bottom of
the pivot table, Excel also shows the total sales for each month for all products.
Refer back to Figure E-14 and note the four small panes in the lower-right corner. The Values pane lets
you easily change from the default Sum operator to another one (Min, Max, Average, and so on). Click the
drop-down arrow, select Value Fields Setting, and then select the desired operator.
BUILT-IN FUNCTIONS
The following functions are referred to in the Excel cases in this text:
￿
MIN, MAX, AVERAGE, COUNTIF, ROUND, ROUNDUP, and RANDBETWEEN
The syntax of these functions is discussed in this section. The following examples are based on the
runner data shown in Figure E-18.
FIGURE E-18
Runner data used to illustrate built-in functions
Search JabSto ::




Custom Search