Get Subtotal of a column in Detail area

OK, I’ve got the grand total in the Page Footer of my Report by using a text box with the accumulation formula for the amtdue column.

So… how do you get a sub-total of one of the columns inside a grouping I have added for the amtpaid column? I have tried to add a text box with accumulation formula inside an amtpaid footer area but that doesn’t work as all it gives is a total for each row in a grouping.

What about using a total in group footer then total group footer amounts for report total.

If this answers your question please tick the :heavy_check_mark: (upper left area of answer). It helps others to know there was an accepted answer.

Thanks Ratslinger,

I added group header and footer where the footer contained subtotal and page header and footer where page footer contains the total. Here is the result.