The SLICER can’t be used anywhere we want.
Here we’ll be discussing slicer with the help of normal tables only. Slicer for the PIVOT TABLE will be dealt in the PIVOT TABLE article only. So let us try to create a slicer for the table.
The SLICER is located under the INSERT TAB in FILTER OPTIONS. The picture below shows the button location for SLICER.
AFTER CHOOSING THE OPTIONS, FOLLOWING PICTURE SITUATION WILL APPEAR.
The slicers have been deployed. Now we’ll see how to use them.
The following picture shows the structure of a slicer.
ALL THE BLUE SELECTED LINES IN BOTH THE SLICERS ARE THE CONDITIONS SELECTED.
We can click on the rows of the slicer to check or uncheck them. As a result of this, the table will alter realtime.
The two slicers are the two conditions. The result is the table which would alter as per the applicability of the conditions.
JUST HAVE A LOOK AT THE ANIMATION PICTURE ABOVE.
We fulfilled all the three conditions by just selecting and deselecting the slicers.
Both the conditions are matched and result is kept in the result table.
This is how easy it is.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE