Microsoft Office Tutorials and References
In Depth Information
Pivoting the Data Sideways Using the Column Labels Area
Drag and drop the
Salesperson bar into the
Report Filter area. In the
PivotTable, you’ll see the
data shown in Figure 8–17.
Figure 8–17. The PivotTable report filter: Just click the
drop-down arrow and select a salesperson
Click the drop-down arrow
and you’ll be presented
with a list of the
salespersons, as shown in
Figure 8–18. The salespersons: Just click one
What happens next is pretty
obvious: click one salesperson
name, and click OK. You’ll see, for
example, the data shown in Figure
Figure 8–19. The sales data for Callahan, and only
Callahan. Note the filter symbol alongside Callahan’s
As with the standard table filters discussed in Chapter 7, we’ve singled out one
salesperson for his or her sales totals. Want to see the totals for another salesperson?
Just click the drop-down arrow again and click someone else.
You can also filter two or more salespersons at the same time:
Click the filter drop-down arrow.
Tick the Select Multiple Items check box.
Click the salespersons you want.
Thus, if you click both Callahan and
Levering, you’ll filter their combined
sales totals, as in Figure 8–20.
Figure 8–20. Double duty: Filtering two salespersons’