Microsoft Office Tutorials and References
In Depth Information
How the Slicer Works
Figure 8–45. The Salesperson field in two places: The Report Filter area and the Slicer
And that’s a bit redundant, because now the salespersons are being filtered in two
places. As a consequence, you can drag Salespersons off the PivotTable, leaving you
with what’s shown in Figure 8–46.
Figure 8–46. There’s no need to use the Report Filter area now, because the Slicer is doing the same job.
And now you can see exactly who’s being filtered.