How to define multiple filter conditions
1  
2  
3  
1  
2  
In Value, select or type the comparison value. For conditions that test equality and for the Between condition, you can either set a literal value or you can base the value on another data column by selecting the Use value from data field option. For example, you can request actual shipping dates that are greater than the forecast shipping dates, or actual sales that are less than sales targets.
The conditions that support basing the filter value on another column are Equal to, Not Equal to, Less Than, Less Than or Equal to, Greater Than, Greater Than or Equal to, Between, and Not Between.
3  
The filter condition appears in the Filters area.
4  
1  
2  
3  
4  
In the Filters area, the second filter condition appears below the first condition, as shown in Figure 7-11. By default, the second condition is preceded by the logical operator, AND.
Figure 7-11  
5  
6  
7  
If you create more than two filter conditions and you use different logical operators, you can use the parentheses buttons to group conditions and define the order of evaluation of the filter conditions.
8  
9  

Additional Links:

Copyright Actuate Corporation 2012