Hi.
I am a user using Jaspersoft Reports server within the NexJ application.
I am trying to create a 'Top 5' or 'Top 10' users for sales.
I created a new calculated measure:
RANK("Sales Amount")
but it is ranking the blank numbers as 1 and then the highest last (eg. 7234).
I am not sure how I can use RANK function to then filter the report to only display the top 10 ranking sales people.
Any thoughts on this?
Thanks