Automated Reports

Hi,

I have created a report pulling in data using filters set in the app. The automated report is grouped by Department.

I want to be able to add a sub-total column after each departments row.

Like Below:

Is there a way to do this?

Thanks

Sorry you haven’t received a quicker response!

Yes, you can add sub-totals but you will need to create it by introducing START:... / blocks into your template. I recommend reviewing the post below for examples. There are other posts that might help as well, just search for “template Subtotal” or “template Group”.

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Subtotal-calculation-in-reports/m-p/487877