Rank Calculated Measure - Jaspersoft Reports Server

Posted on November 23, 2015 at 5:09pm
0

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

 

troy.funslow's picture
troy.funslow
2
Joined: Nov 5 2015 - 11:01pm
Last seen: 4 years 10 months ago

1 Answer:

0
Posted on November 25, 2015 at 5:39pm

I don't think there's a way to do this with existing calculated fields. However, in JasperReports Server 6.2, we added a Top N filter, which does exactly what you want.  

elizam's picture
elizam
5131
Joined: Mar 5 2012 - 9:19am
Last seen: 1 month 4 weeks ago
Feedback
randomness