We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Get Subtotal of a column in Detail area [closed]

asked 2017-12-22 18:00:30 +0200

kasloman gravatar image

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.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2021-02-10 13:50:21.961429

2 Answers

Sort by » oldest newest most voted

answered 2017-12-22 18:05:25 +0200

Ratslinger gravatar image

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

edit flag offensive delete link more


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

Ratslinger gravatar imageRatslinger ( 2017-12-22 23:33:36 +0200 )edit

answered 2017-12-22 22:38:13 +0200

kasloman gravatar image

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.

image description

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2017-12-22 18:00:30 +0200

Seen: 196 times

Last updated: Dec 22 '17