Changing the evaluation order of qualifications in a filter

Qualifications in a filter are evaluated in the order in which they appear, with the qualifications at the top of the filter being evaluated first. Qualifications that are grouped and indented to the same level are evaluated together.

For example, a filter is defined as:

Region = Northeast AND Revenue > $1 million OR Revenue > $2 million

where Region = Northeast and Revenue > $1 million are grouped together. When the filter is applied, data for the Northeast region where revenue is greater than $1 million is displayed, along with data from any region where revenue is greater than $2 million.

You can use the Filter Editor to change the order in which filter qualifications are evaluated by moving a qualification up or down in the filter, or group qualifications together by indenting them to the left or right.

Prerequisite

The following procedures assume that you have already created a filter with multiple qualifications. For steps to create a filter, see Creating a stand-alone filter or Creating a filter within a report.

To move a qualification up or down in the filter

1. Double-click the filter to edit. The Filter Editor opens.

2. In the Filter definition pane, select a qualification, then do one of the following:

   • To move the qualification up in the filter, click Move Up.

   • To move the qualification down in the filter, click Move Down.

To move a qualification left or right in the filter

To move qualifications left or right, the filter must have at least three qualifications.

1. Double-click the filter to edit. The Filter Editor opens.

2. In the Filter definition pane, select a qualification, then do one of the following:

   • To indent two qualifications to the left, select the operator between the qualifications and click Decrease Indent.

   • To indent two qualifications to the right, select the operator between the qualifications and click Increase Indent.