I've got a problem with the grouping and sorting of a report.
The report shows a list of unpaid invoices. These invoices should be grouped by debtor, and sorted by age of the debt.
So this is what it should look like:
x 240 days
a 239 days
a 40 days
g 239 days
o 220 days
But how do I achieve this?
If I put the group by debtor first in the group/sort by menu of the report, it puts the whole list in order of the debtor's name.
If I put the order by age first in the group/sort by menu of the report, it doesn't group at debtor level anymore...