Sorting on SUM, with 2 tables

I have a question on sorting.
I am using an NL to give me my list of customers.

Then i use 4 consecutive NL ("Sum") to give me totals if different date ranges.

But I would like to be able to sort it by the yellow cell, J10, largest values to smallest.

Since my initial NL is from a different table, how can I sort this?

And if I can get this to work, can I have multiple sorts like in Excel ?

So i my case, I would sort, largest to smallest, the yellow cell, green cell, pink cell, blue cell.

Please see the attachement.

I am using NAV 5.0 SP1
Jet 9.1


Please sign in to leave a comment.