Top 5 most listed Service Items

Jet Reports Historic Posts

August 15, 2014 13:26

None

Hi there,

please can anyone help me with the NL-function. How is it possible to list the top 5 most listed service items.
I have the list (NL-row-funktion) with all service items but with no value on these items. Therefor i just want to count the frequency and display the items with the highest amount.

Thanks in advance
kjube

jet-essentials
NAV 2k9

Date Votes

1 comment

0

Jet Reports Historic Posts August 15, 2014 20:31

Looks like you are going to have to do something similar to sorting by a sum, but in your case, sort by count.

You can find a great explanation of how to do this at this post http://community.jetreports.com/viewtopic.php?f=23&t=2109&p=6140&hilit=easiest+way+to+teach#p6140

Since you only want the top 5, you will also need a Limit= filter set to 5.

Hope that helps.

Comment actions Permalink

Please sign in to leave a comment.