Hi Jet Report Support,
We added a new field called 'Style' in Item table. Now we create a report to show the Sales (LCY) in Item table with a specific date filter group by Style to show the Item No., Description and Sales Amount.
Can we sort the records base on the 'Sales (LCY)' of Style Sub Total?
Hi Byron.
I'm not in Jet Reports Support...
(if you have a support issue, you can contact them by submitting a support request)
However, are you looking for something like this (where I've created a grouping report that includes a subtotal) ?
By adding the Sort-by-Sum technique to the NL(Rows) function in cell D4:
=NL("Rows=4","Item Ledger Entry","Item no.","-=NL(""Sum"",""Item Ledger Entry"",""Sales Amount (Actual)"",""Item No."",NF(,""Item No.""))","*")
My report is sorted by the subtotal:
