How to use Slicer for effective filtering of Pivot Data in MS Excel?

About Slicers in MS Excel

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.

Step 1: To get the Slicer option you have to go the "Insert" Ribbon's "Filter" tool. There you will have two options 1) Slicer and 2) Timelines.

Step 2: Create you pivot table and then click Slicer. You will get the Slicer selection list.



Step 3: Select the Year and Margin or all three. You will get the slicer of your pivot table.