Hi,
I need to group on a sumarised field basically. Now I know this isn't possible as such, but is there a way round it?!
I'm using SAP crystal, and have various fields, invoice, invoice number, dept, client number, invoice amount, and a few others.
I want to basically sum the total of the invoice amount, per client number, and then group this by using the total of the invoice amount to group it into credit and debit per dept. It would look something like this:
Dept A - Credit
ClientNo SumInvoiceAmount
123ABC -12330.00
156XYZ -5623.52
Totals: -17953.52
Dept A - Debit
ClientNo SumInvoiceAmount
123ABC 6235.22
156XYZ 521.00
Totals: 6756.22
Is it possible?
Thank you!
Di
I need to group on a sumarised field basically. Now I know this isn't possible as such, but is there a way round it?!
I'm using SAP crystal, and have various fields, invoice, invoice number, dept, client number, invoice amount, and a few others.
I want to basically sum the total of the invoice amount, per client number, and then group this by using the total of the invoice amount to group it into credit and debit per dept. It would look something like this:
Dept A - Credit
ClientNo SumInvoiceAmount
123ABC -12330.00
156XYZ -5623.52
Totals: -17953.52
Dept A - Debit
ClientNo SumInvoiceAmount
123ABC 6235.22
156XYZ 521.00
Totals: 6756.22
Is it possible?
Thank you!
Di