Cell Filtering

Learn how to search the table cells for an specific value.

If you have to search for a precise value, you can right-click on the table and filter by a cell's value.

The action searches the exact value match on that table column.

Example

The cell filtering of "Pizza" will yield only the column's cell values containing "Pizza". The action excludes values that contain "Pizza" but aren't an exact match; e.g. "Pizza Dinner", "Pizza Delivery", etc.

Note

According to the Designer's choice, you can't filter a table for certain columns. There could be two reasons:

• The Designer has configured the desired column field as not searchable.
• The column you want to filter is a Logical Column: columns that calculate data in real time without saving them. Logical Columns aren't filterable. (See Configure Calculations Without the Necessity of Storage: Logical Columns in the Designer Guide to learn more about Logical Columns.)

In both the cases, you can't sort a filter the table for the column.

1. Right-click on the cell containing the value you want to filter by.

2. Choose Filter from the options.

   

The table will filter the rows by the chosen cell's value.

Note

If you choose filters for a Detail table, the filtering options will be valid only for the current Detail table. The filtering options won't be applied on Details of other Master rows.

See the What are Details? section for more information about Detail tables.