Microsoft Office Tutorials and References
In Depth Information
4. Next, drag the Product field to the Drop Row Fields Here area. You should see the result shown
in Figure E-16.
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
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.
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.
Runner data used to illustrate built-in functions