1 Select the report column that contains the values to evaluate, then choose Filter from the column toolbar.
2 On Filter, choose Advanced Filter. Advanced Filter appears. Filter By displays the selected column.
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 In Value, select or type the comparison value. You can select Specify literal value, or Use value from data field.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
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.
|
|
Copyright Actuate Corporation 2012 |