Multi-Select Slicer Items in Microsoft Excel Pivot Tables
If you are wondering what is slicer; it helps to add a level of interactivity in our reports. Even you can use the multi-select slicer items too. You only have to click on your slicer and then it will be enabled.
NOTE : You can create random excel workbook online here for practice purposes as I did in this tutorial.
Following are the steps to follow:
STEP1. To insert a new pivot table follow this: click on your data firstly then
Insert > Pivot Table > New Worksheet or Existing Worksheet
STEP2. Put in the Name field in your ROWS section while in the VALUES section put in the Cash field.
STEP3. Now add the slicer by following:
Go to PivotTable Analyze > Filter > Insert Slicer
STEP4. Click OK but make sure you have selected GENDER Option.
Now you are having your slicer, so you just need to tick only the Multi-Select button to enable this.