Grouping filter criteria

To combine filter criteria, group the filter lines. This enables you to create complex filter expressions that rely on multiple data items and values. You can use complex criteria to display ranges of items based on minimum and maximum values that you set in the Filter editor or in the cells of the Microsoft Excel worksheet.

Procedure

  1. Ctrl+click the items you want to group.
  2. Click the Group Selected Filter Lines icon.