I have a Salesperson Report that I need sorted by the Salespersons' subtotal of sales for the month. I know this isn't really a Jet specfic question, but does anyone know if there is a way to do it?
I have attached my report.
I am using Jet 2009, Excel 2003, NAV 5.1 SP 1
Date
Votes
5 comments
-
Jet Reports Historic Posts Official comment Yes. Thank you!
-
Jet Reports Historic Posts Hi HPG1,
I believe what you want is a "Sort by Sum". To do this with a Nav connector you must use a Calc-FilterField. I'm attaching an example. -
Jet Reports Historic Posts It worked. Thanks!!
-
Jet Reports Historic Posts Ok so this worked for the most part, but some of the totals are still out of order and I don't understand why. See the attached report. Thanks.
-
Jet Reports Historic Posts Hi HPG1,
You should notice that the previous sort by sum formula only included a sum of the amounts from the Sales Invoice Header. However, in your report you are also summing amounts from the Sales Cr. Memo Header. Therefore your sort by sum formula also needs to include the sum of amounts from the Sales Cr. Memo Header or else it will not be sorted correctly. I am attaching an example that I believe should do this. Does this work for you?
Regards,
Hughes
Please sign in to leave a comment.