Filters provide the ability to filter the data based on the specific value, color, and condition. It helps users to view only the filtered data and hide the rest of the data.
Users can filter the data by creating a filter selection on a single column or on multiple columns, which provides the best possible way to view only the required data out of the entire data set.
and in this tutorial, we will show you how to filter the data by creating multiple filters selection on a single data set.
Steps to Filter Data by Creating Multiple Filters
Let’s take an example, we have data on employees who sell different types of items and we want to see the data for a specific employee’s sales for a particular item. For this, we will create two filters, one on the employee’s name and the second one to filter the item name.
- First, Apply a Filter to the data set.
- After that, click on the filter Icon of the “Sales Person” column as we have to filter the data for a specific employee.
- Here, in the filter options, click on “Clear” to un-select all the selected values (names), and then click on the name, only whom you want to filter.
- Once done with the name selection, click OK.
- At this point, you will view the data only for the employee (Harpal), but with all the types of items that that employee sold.
- Now, click on the filter icon of the “Item Name” column and select only the “Hardware” item and then click OK.
- Here, you will find the more filtered data based on two filter conditions (Name and Item type).
Note: We have shown you the example of two filter creations, but as per your requirements you can create more filters as you want.