Understanding ranking
Video tutorial
Use ranking to create a new column with the rank for each subset of records relating to the same key. Ranking allows you to rank a table based on a specific column. For each subset of records associated with the same key in a table, a sequence number is assigned according to the relative value of a given field. Ranking is used, for example, when trying to identify the first products purchased by each customer, or the most recent product purchased.
How to create a ranking column
1  
2  
3  
4  
5  
Figure 3-19  
6  
7  
8  
Video tutorial
Creating a ranking
 

Additional Links:

Copyright Actuate Corporation 2013 BIRT Analytics 4.2