Microsoft Office Tutorials and References
In Depth Information
Comparing the Data
Figure 8–16. No mean feat: Changing the mathematical operation of a field to Average
The salesperson data now display average sales by salesperson. Click the Summarize Values By
drop-down arrow and you’ll see that you can also carry out these operations: Count, Max, Min, and
Product (which in our case would multiply each salesperson’s sales all together, yielding a rather
gigantic total). Clicking More Options gives a few additional possibilities, including Standard
Deviation . (By the way, we’ll get to how to format these data in a little while.)
Comparing the Data
And here’s another cool way to characterize your data. By clicking anywhere in the pivot report and
then clicking PivotTable Tools Options tab Calculations group the Show Values As drop-down
arrow, you’ll see (Figure 8–17):
Figure 8–17. The Show Values As drop-down menu: more ways to compare the numbers
Search JabSto ::

Custom Search