Filter Rules

You can create filters with one or more conditions for what data to display.

To use filter rules, follow the steps below.

  1. Go to the View tab and ensure filtering is Enabled.
  2. Click Filter Editor.
  3. For each filter group, select it and choose one of the below options.
    OptionDescription
    And All conditions in this group must be true.
    Or One or more conditions in this group must be true.
    NotAnd One or more conditions in this group must be false.
    NotOr All conditions in this group must be false.
    Add Condition Add another condition to this group.
    Add Group Add another filter group.
    Clear All Removes all items nested within this group.
  4. For each condition, fill each field.
    1. Select the field this condition is based on.
    2. Select the condition it must use. This determines how the data from the selected column is compared to the provided value.
    3. Enter in a value to compare the field against.
  5. Click Apply, then OK.