i want to rank my report by units sold...also want to show only 100 records....is there any one can help with this...
Hi
Try using rank (ie rank the items in the report) then use a filter on the ranking (<101)
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
:)
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 )