Filtering by field values

This method enables you to display the records that contain a certain value in the chosen field (column).

To filter the records by multiple field values:

  • Click the Quick Filter icon in the column heading and choose the values by which you want to filter the records from the list of the field’s unique values.

To filter the records by a certain field's value:

  • Right-click the cell containing the value you want to filter records by and choose Filter > Filter by Selected Field from the pop-up menu.

Once you’re done, the list appears filtered by the chosen value. You can see the filtering condition in the Condition Panel that is shown at the bottom of the window.