Filter column data

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:

  1. Click the Filter button above the column. This highlights the column and opens an "Add filter value" search box

  2. Enter your search filter value. The column dynamically updates when entering the term to display the search results as you type

  3. If required, use the Reset button to clear the search box

  4. 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:

  1. Use the above steps to add the first column filter(s)

  2. Click on the next column and enter the "Add filter value" criteria

  3. Repeat these steps until you have created your filtered view.

  4. 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.