Microsoft Office Tutorials and References
In Depth Information
Filters Again-PivotTable Style
Consider our pivot report as it currently stands, as portrayed in Figure 8–30. We’re looking at the
number of sales registered by each salesperson. Now suppose we want to concentrate on King’s sales
data alone (remember-if our sales force numbered 90 or 900 operatives instead of the nine in our
report, our interest in plucking just one salesperson out of the mass of employees might be more
illustrative). The method here is pure AutoFilter:
Click the handle alongside Salesperson. You’ll see (Figure 8–34):
Figure 8–34. You’ve seen something like this before, too—a filter drop-down menu, here in PivotTables.
Click (Select All) . All the checks alongside all the Salesperson names
di sa ppe a r .
Click OK. You’ll see (Figure 8–35):
Figure 8–35. Royal total: King’s number of sales
You get the idea. To restore all the salesperson names, click the filter handle again and click either
Clear Filter From Salesperson , or click the now-blackened (Select All) box above all the salesperson
names. All the names reappear. If you want to filter several names, just click the check box alongside
those salespersons you want to see after clicking Select All off.
And similar to AutoFilters, you can customize what it is you’re looking for by selecting either the
Label or Value Filters option on that same drop-down menu (Figure 8– 36):