Filter, group and order

Filtering by a field's items

A check-list of a field's items: tick what to keep.

The check-list

  1. Filter items… (in a field's menu, or on its name in the grid) opens the field's check-list: its items, each with how many records stand under it, the most frequent first.
  2. Search it, Select all or Select none, and tick what to keep.
  3. Apply.

A filtered field says what it keeps above the grid; × clears it, Clear all clears every one.