If we are analyzing dataset using pivot tables like this:
Let suppose there are many values in column selected as filter (here we want to know detail month wise – it has 12 values), so each time selecting value from drop down is little difficult.
Slicer can be used to simplify this scenario, as it will give a box having all possible values in selected field:
It is very easy to bring slicer in front, just follow below steps:
Step1: Keep mouse on pivot table
Step2: Insert -> Slicer
Step3: Select the column name which you want to use as filter (show in slicer)