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

areas

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