Bottom Up Ranking (ReportNet)

[AMussell]

I have a report that list products by gross sale amount and a calculated column 'Rank' that ranks them based on the statement;

"rank([Gross Sale Amount])"

I can then sort the top 20 products by filtering where;

"rank([Gross Sale Amount])<= 20"

I also wish to view only the bottom 20 ranked products but am having GREAT difficulty doing so dynamically. I would like to be able to determine the rank of the lowest product - say 297 - and filter on products with rank 20 or less than that.

Any ideas would be appreciated.
Thanks
Andy

 

[jo0001]

Hi Andy,

I'm not sure wether I got your question right, but couldn't you just limit the number of displayed rows in your report and then sort asc or desc by leaving the ranking how you did it?!

Just come back if that isn't a solution for you, ok?!

Jochen

 

[Draoued]

Can you do something like:
rank([Gross Sale Amount]>= maximum(rank([Gross Sale Amount]) - 20

 

[Mailpack]

I would use rank([Gross Sale Amount]*-1)
This would give you a reverse ranking, and then use rank<20 to filter the report.