Microsoft Office Tutorials and References
In Depth Information
Pivoting the Table
Figure 8–29. Starting over; stay tuned
Then click on Salesperson again in the PivotTable Field, and drag it into the Values area…as
murmurs of discontent flit across the hall. First, you’re asking rhetorically, haven’t we already used the
Salesperson field, having locked it into in the Row Labels area? And second, didn’t I earlier say that
fields in the Values area are always subjected to a mathematical operation? Well, Salesperson
contains text data—the names of the salespersons in our pivot report—and how do you subject names
to a mathematical operation?
You have a point—or two. To get to the second question first, it’s true that you can’t add or take an
average of text data, but there is one operation to which you can subject them: you can count them. And
when you drag Salesperson into the Values area that’s exactly what happens (Figure 8–30):
Figure 8–30. Number of sales by salesperson: Using the Salesperson in both the Row Labels and Values
The pivot report, then, has no choice but to count the salesperson names once they’re assigned to
the values area—but why would we want to do such a thing? Here’s why: because we’ve also left the
Salesperson names in the Row Labels area, we’ve engineered a count of the number of sales each
salesperson has attained. We’ve told the pivot report to count each instance of each salesperson’s
Search JabSto ::

Custom Search