Slicers to Filter data of Pivot Table in Excel

Slicers to Filter data of Pivot Table in Excel

Slicer are used to filter the Pivot table in Excel slicers are the filtering component 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.
You can also add Slicers with  Olap cubes functions.(SSAS)

Slicers are same as Report Parameter in SSRS .

Below is the example how to add a slicer in the pivot table to filter the data.

if you want to know how to create a pivot table in excel then read my previous blog on
Creating Excel Pivot table

http://sqlandssrssolutions.blogspot.in/2013/12/creating-excel-pivot-table-using-sql.html 

we will add slicers to same pivot table which we created on our previous blogs.
.

we have 3 columns in our pivot table we will add slicers (empname and empid ) to filter the pivot table based on empname and empid

so below are step

First create a pivot table using the above link
click anywhere in your pivot table
Insert tab
click on Slicer
It will display all the column of your pivot table with checkboxes.
Select the checkbox for which you have to  add slicer in our case we are adding Empname and Empid

It will add two slicer in your Sheet.

Adjust the Position of Slicers.

click on any values of slicer to filter the report the Report will be filtered based on your values selection in slicer.

press Ctrl key with mouse click to add multiple values in slicer..

In order to clear all the filter from slicer click cross sign highlited in red in below screenshot.