Table filters

Tables display data in a column and row format. Customize some tables by repositioning columns, changing the order of data within the columns, and applying filters to columns to focus on your priorities. This applies to data shown in table formats.

Table filters are available to select table columns.

Change column positions

The table has multiple column headers. Adjust the layout of these columns in the following ways:

• Move a column: Click, hold, and drag the column header to a different position. Release the mouse button to drop the column into its new position. The column moves to the new position.

Sort

Sort the columns in ascending or descending order. Click the heading cell of the column you want to sort. An arrow appears to indicate the sort order.

• Up arrow for ascending order.

• Down arrow for descending order.

Filters

Narrow the results shown in the list using filters. They help you sort through large amounts of information to find specific data that meet the filter criteria you set. For instance, you might set a filter within a building list to display only specific buildings.

When you apply a filter to a column, an x icon appears next to the filter icon, indicating that a filter is active on that column.

Apply filters to different columns in the list to refine your search results.

Conditional filters

Conditional filters refine the results. For example, choose to only filter items if the cell starts or ends with specific letters or contains certain words.

1. Click the filter icon located at the top of the column you want to filter.

2. Select a condition from the options provided, such as Contains, Equals, and others.

3. In Filter, enter the text or value that corresponds to the first condition you've selected.

4. To narrow down the results even more, you can choose either And or Or to add a secondary condition.

5. Select another condition for the secondary filter.

6. Enter the text or value associated with the second condition.

7. Click Apply.

   The column data filters according to the conditions and criteria you set.

8. To remove the conditional filter, click the X next to the filter icon, then click Reset in the filter window.