Where a column has a Filter button, you can use this to organize your data easily and display the details you are looking for. This is particularly useful for providing targeted information when working with large datasets.
To use column filtering:
Click the Filter button above the column. This highlights the column and opens an "Add filter value" search box
Enter your search filter value. The column dynamically updates when entering the term to display the search results as you type
If required, use the Reset button to clear the search box
Click Close to remove the "Add filter value" bar and display the filter criteria
You can filter column data, drill down on each column individually, or combine filters across multiple columns to provide a more targeted view.
To filter across multiple columns:
Use the above steps to add the first column filter(s)
Click on the next column and enter the "Add filter value" criteria
Repeat these steps until you have created your filtered view.
Click Close to remove the "Add filter value" bar and display the filter criteria across the columns
For additional customizable view options, column filters can be combined with column groupings.