Add filters to your grids to change the data that displays in them based on certain conditions.

You can create filters when you design or edit a custom view. The filter conditions you can select when you create a filter depend on the type of data you filter. 

When you filter line items, filters apply to the values of all line items. You can only filter number-formatted line items.

You must open your page in designer mode. Select Edit .

To create a filter:

  1. Select Configure grid on a new card, or hover over your card and select Edit .
    Read how to add a card to a board or worksheet. On the Overview tab of the Card configuration panel, select View, then choose a custom view from the Select data source panel. 
  2. On the toolbar, select Filter .
  3. Choose Rows or Columns to select the axis to filter.
    If you select an axis that does not contain line items, you can apply filters to the values of an individual line item.
  4. From the Show items that match dropdown, choose All or Any.
  5. Select Add rule, and:
    • Choose a module to apply the filter to.
    • Choose a filter condition from the Select filter condition dropdown. 
    • Enter a value. 
  6. Select Apply, then select Update.

Note: When you filter a list, you can only select one item as the filter condition. The dropdown list displays the first 50 list items. For lists containing more than 50 items, enter a search term in the list field.

The Filter dialog displays to the right of the Select primary grid dialog. The mouse pointer is hovered over the Filter icon on the grid toolbar.

A filter becomes invalid when the data it refers to becomes inaccessible or is moved. In the filter panel, a warning icon displays on the axis and filter that you need to reconfigure or delete.

To reset a card, select Filter , then select Remove all filters on the Filters panel.