Working with Slicers
Here, the working of a slicer will be demonstrated by taking an example of a pivot table. Suppose we have an IMDb dataset of all the movies released in 2016 worldwide with their ratings, budget, gross revenue, country, genre, and many more things.
Suppose we want to know the budget of all the movies by country filtered by genre. For eg: We want to know the budget of all the movies in the U.S.A and the U.K. which are of the comedy genre.
We can do this in two ways:
- By dragging the genre into the filter box in the field list of the pivot table
Budget of comedy films in the U.S.A and U.K
Field list of the pivot table
- Secondly, we can do the same thing by using slicers.
Select the column on the basis of which you want to filter data
Budget of comedy films in the U.S.A and U.K
So, we can see that we obtain the same results from both ways. So we can say that slicers work exactly the same way as dragging a field into a filter box in the field list of the pivot table, and they add a user-friendly interface to filter the data.
To select multiple genres, we need to enable the option of Multi-select in a slicer or just press shift and select any other genre. For eg: The picture below shows the total budget in the U.S.A and U.K. for both comedy and crime genres.
Pivot Table Slicers in Excel
Slicers are the visual representation of filters. By using a slicer, we can filter our data in the pivot table by just clicking on the type of data we want. Slicers are found in the Analyze tab of the pivot table tools. We have an option called Insert Slicer and on clicking it, we have to select the column on the basis of which we need to filter our data.
Contact Us