Microsoft Office Tutorials and References
In Depth Information
The Slicer—Filter Deluxe
Figure 8–50. Still Slicing, even though the Salesperson field has been removed from the PivotTable
Here the Report Filter is vacant, and yet the Slicer is still slicing. And yes, Slicers can be resized
and moved about the worksheet, and they will print along with the pivot report.
Slicers also alleviate a problem we identified a bit earlier. First, you can introduce as many slicers
into your worksheet as there are source data fields—and they slice each other. That is, if you call up
Slicers for both Country and OrderID, by clicking UK in the Country Slicer , you’ll restrict the Order IDs
that appear in the OrderID Slicer to the UK sales only.
With the Slicer, it’s now possible to construct a pivot report containing only one field in its grid,
with Slicers contributing all the other input. Thus if I place the Order Amount data in the pivot report
Values area I can then manufacture a Salesperson Slicer and click the names there—right on the
Slicer—and still see the sales data change in the Values area. (Clicking the X you see in the Slicer’s
upper right corner won’t turn the Slicer off—it’ll turn the filter off, meaning it’ll click all the items in
the Slicer on, for tallying in the pivot report. Thus clicking the X on the Salesperson Slicer means data
for all the salespersons will be applied to the pivot report.)
Thus the Slicer is a kind of free-standing, offshore filter which isn’t locked into the pivot report
grid, rather doing the work of filtering at a distance—sort of a Bluetooth, hands-free extension of the
pivot report, meandering around the worksheet wherever you position it, but still impacting the report
in important ways.
To add a Slicer—or Slicers—click anywhere in the pivot report and then click PivotTable Tools
Options Insert Slicer… .You’ll see (Figure 8–51):