Jump to content

Rank Calculated Measure - Jaspersoft Reports Server


Recommended Posts



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? 




Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...