In earlier versions of Microsoft Excel, we can use report filters
to filter data in a PivotTable report, but it is not easy to see the current
filtering state when you filter on multiple items. In Microsoft Excel 2010, you
have the option to use slicers to filter the data. Slicers provide buttons that
you can click to filter PivotTable data. In addition to quick filtering,
slicers also indicate the current filtering state, which makes it easy to
understand what exactly is shown in a filtered PivotTable report.
Slicers are easy-to-use filtering components that contain a set
of buttons that enable you to quickly filter the data in a PivotTable report,
without the need to open drop-down lists to find the items that you want to
filter.
When we use a regular PivotTable report filter to filter on
multiple items, the filter indicates only that multiple items are filtered, and
we have to open a drop-down list to find the filtering details. However, a
slicer clearly labels the filter that is applied and provides details so that
you can easily understand the data that is displayed in the filtered PivotTable
report.
Slicers are typically associated with the PivotTable in which
they are created.
When
we create any slicer we get the following elements
1.
A slicer header indicates the category of the items in the slicer.
2.
A filtering button that is not selected indicates that the item is not included
in the filter.
3.
A filtering button that is selected indicates that the item is included in the
filter.
4.
A Clear Filter button removes the filter by selecting all items in the slicer.
5.
A scroll bar enables scrolling when there are more items than are currently
visible in the slicer.
No comments:
Post a Comment