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  
2  
3  
4  
5  
6  
7  
Figure 5-9  

Additional Links:

Copyright Actuate Corporation 2013 BIRT iHub 2