How to do Sub Total on a Report

[lklp]

I have a report with Amount and Grand Total on it, but I don't know how to do Sub Total Amount by Magazine. Please see attachment for the screen shot and the report details.

 

[pbaldy]

Copy the textbox with the grand total in it and paste it into the group footer.

 

[lklp]

Thanks Paul, but I only see Page Footer and Report Footer. I don't see Group Footer. Can you explain further?

Thanks and appreciate your help!

 

[pbaldy]

Go into Sorting and Grouping and click in the Magazine row. Down below in the properties you will see Group Footer, which should be changed to Yes.

 

[lklp]

Thank you so much Paul! It works like a charm.