Database Reference
In-Depth Information
Filters versus Slicers
We can add extra functionality by going to the Ribbon, as shown in Figure 5-19,
and inserting a
slicer
(a visual filter), or we can use the built-in Excel filters (see
Figure 5-20). Inserting a filter is as easy as dragging the column you want to
filter by into the filter area in the Field well (where you just dragged the other
columns).
FI g u R e 5-19
Inserting a slicer from the Ribbon
Inserting a slicer is one extra step. You need to click on your pivot table some-
where and select Insert
a
Slicer. Then you can choose the fields you'd like to
slice by. These function as live filters on the canvas as opposed to in a drop-
down list, so they are better for common filters that users would combine.
They are also sometimes more visually preferable to regular filters. The slicers
we chose are shown in Figure 5-20.
See how easy that was? Now we can format and sort our report using some
of the cool functionality in Excel.
