1. Anaplan User Experience
  2. Use apps and pages in the User Experience
  3. Filter
  4. Add a filter

Add a filter to a column or row of data to display only the data items that match the specified criteria.  

On worksheets, you can find the Filter icon for the main grid in the worksheet toolbar (or the toolbar on an expanded grid card):

A worksheet displays with the Filter icon highlighted in the toolbar at the top of the grid. It is the third icon in from the left.

On boards, hover your cursor over the grid card to which you want to apply a filter. The Filter icon displays in the top-right corner.

To add a filter:

  1. Click the Filter icon.
    The Filters panel displays on the right. On a worksheet, the Filters panel displays in place of the Additional insights panel.
  2. In the grid, select the column or row you want to filter.
    A new filter displays at the top of the Filters panel. The title of the column or row is automatically added as the title of the filter.
  3. From the Select condition dropdown, choose a filter option.
    The options displayed differ, depending on the data type of the data in the column.
    If the column contains list items, you can choose multiple list items by which to filter the grid. You can remove the filter for a selected list item by clicking the cross (X) next to its name.
    To search within a list that contains a lot of items, click within the list field and type a search term. The list then updates to display only those options that contain the search term.
    These are the filter options:
ConditionOnce selected...
Is truethis returns only the data items with a checked box.
Is falsethis returns only the data items with an unchecked box.
Equal to/Is not equal toenter the value by which to filter the data.
Greater thanenter the value that determines the lowest value by which to filter the data.
Less thanenter the value that determines the largest value by which to filter the data.
Greater than or equal toenter the minimum value by which to filter the data.
Less than or equal toenter the maximum value by which to filter the data.
Between or equal toenter the two values by which to filter the data.
Is blankthis returns only the data items that have empty cells for the selection.
Is not blankthis returns only the data items that have cells containing data for the selection.
Containsenter the text to search for.
Start withenter the text to search for at the start of a selection.
End withenter the text to search for at the end of a selection.
  1. Optionally, to add further conditions, click the plus sign (+) to the right of the first condition's value field.
    To remove a condition, hover your cursor over it so that it turns gray and click the minus (-) sign on the right.
  2. In the bottom-right of the Filters panel, click Apply to update the grid.
    In the grid, a filter icon displays at the top of the filtered column.
    This identifies which columns have filters, even when the Filters panel is hidden.
    When you select a filtered column on a grid, it displays within a blue outline. In the Filters panel, the corresponding filter displays with a blue line on its left.
A worksheet with filters applied to its Region and PY Sales columns.