show top 100 records

[Maple]

i want to rank my report by units sold...also want to show only 100 records....is there any one can help with this...

[trevorp]

Hi

Try using rank (ie rank the items in the report) then use a filter on the ranking (<101)

[vijayab]

In the Query create a data item as rank= rank(units sold column)
And in filter rank<=100 and in properties of that filter make it After Auto Aggregation.

Hope it wil help u ..
vijayab
:)

[GangXiao]

This function sorts a set according to the values of "numeric_exp" evaluated at each of the members of "set_exp", and returns the top "index_exp" members.

Syntax
topCount ( set_exp , index_exp , numeric_exp )