0

NL Rows sort order

Jet Reports Historic Posts

August 06, 2015 12:13

None

Follow

Hi,

Jet 15.1. Data source is NAV 2013.

I am returning rows using the following NL function:

=NL("Rows","LOB Posted Table","Customer Account No.","Customer Account No.",$I$5) (Where LOB Posted Table is a custom NAV table).

The rows are returned in alphabetical order of Customer Account No i.e. A1, A2, B1 etc etc). I would like it to sort by a count function (with date filter) - how do I do this please?

Many thanks in advance.

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts August 07, 2015 16:49

  Hello.
  
  What you need is to use the Sort of Sums function. Here is a link.
  Sort of Sums: https://community.jetreports.com/viewtopic.php?f=23&t=2109&p=10489&hilit=sort+by+sum#p10489
  
  I hope think helps. If you get stuck then I know the guys at Jet are always available to connect with you and work together.
  
  Best.
  Jason