Ask Your Question
0

Get Subtotal of a column in Detail area

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 close merge delete

2 Answers

Sort by » oldest newest most voted
0

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

Comments

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
0

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 84 times

Last updated: Dec 22 '17