When creating a report filter with multiple elements, the order of evaluation in the filter becomes very important. To manipulate the grouping and order of evaluation in the filter, Strategy provides arrow buttons to graphically control the grouping and order of evaluation.
To group and ungroup elements, the indent button is used. For example, to create the filter:
(Month: January AND Year: 2000) OR (Month: March AND Year: 2001)
Year and Month of Year are grouped by using the indent button, as shown below:
If no indentation arrow appears, as is the case with the OR operator directly above the arrowed example, it is by design. This occurs when it is not possible to change the order of operation. It can be resolved by un-indenting the surrounding operators.
Below is the result of a report run with the filter above. It shows January 2000 and March 2001:
