Comparing to a value in another column

Use a filter condition to compare the values in one column with the values of another column. For example, in a report that displays products, sale prices (Price), and MSRP (Manufacturer Suggested Retail Price), as shown in Figure 5-9, you can create a condition to compare the Price and MSRP of each product. You can then create a filter to display rows where Price is greater than MSRP.

How to compare to a value in another column

1	Select the column that contains the values to compare, then choose Filter.

2	On Filter, choose Advanced Filter.

3	In Condition, select a comparison operator.

4	Choose Use value from data field.

5	From the drop-down list that appears, choose the column that contains the values to compare to the first column, as shown in Figure 5-9.

6	Choose Add Condition.

7	Choose Add Filter, then choose OK.

Figure 5-9

Building a comparison filter using Advanced Filter

© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy

BIRT iHub 2