Let me clarify Olly. I am using a report with approx 50,000 loans on it. There are multiple amounts columns, principal, interest, fees, discount etc.
I wanted to have the amounts totaled by type and have a stacked subtotal extract.
2014-09-30 $10,000,000.00 Principal
2014-09-30 $50,000.00 Interest
2014-09-30 $1786.30 Fees
2014-09-30 $72.12 Discount
and not have them all on one line....