Combining filters

Combine two or more filters to create a complex filter. For example, you can filter the columns Site Name, Visit Name, and Actual Date in a report.

From the Edit Data menu, select Combine Filters.
To add a filter, click Add a filter line.
To select a set of filters, click the name of the filter while holding down Ctrl or Shift.
Click Group.
Click the operator that appears between the filters and select AND or OR to combine them.
To convert a filter line or a combined filter into a NOT filter, click the filter line or combined filter and click Apply NOT.
Click OK.