A Rank data group takes the data from another data group in the DSD and ranks its rows based on numeric values in selected fields.

Select the data group to be ranked and then drag and drop fields into the Fields box. The combination of the values in these fields will be ranked by how many times the combination occurs.

Use the Function Builder to add an optional filter which is executed on each row the the target data group and only ranks those that return “true”.

To rank by the least first, check the By Least option.

By default, all ranked rows are returned but you can limit the results to a number of rows using the “Top” setting. Note that if, for example, you limit to 5 and the fifth and six rows returned have the same rank, both will be returned. The top n rows are returned plus any that tie with the nth row.

The following fields are returned for each ranked row:

• Selected fields - a column for each field that you ranked by
• _count - the number of rows found with the combination of field values
• _percent - the percentage of rows found with the combination of field values
• _rank - the ordinal position or ranking of the combination of field values