Hi Experts, I have been struggling to use subtotals in my output. Is there a (simple) way to include subtotals in the output? Below is a sample data. ClassSectionStudentsIA100IB150IIA200IIB250IIC300 I would like to have subtotals for each class like the ones we see in pivot tables. I tried the CReW macros(Add Totals), but it totals the full range and not by each group. My workflow goes - Many tools to Union-Summarise-Table-Layout-Render. Thanks!

Subtotals

Hi Experts, I have been struggling to use subtotals in my output. Is there a (simple) way to include subtotals in the output? Below is a sample data.

Class	Section	Students
I	A	100
I	B	150
II	A	200
II	B	250
II	C	300

I would like to have subtotals for each class like the ones we see in pivot tables. I tried the CReW macros(Add Totals), but it totals the full range and not by each group. My workflow goes - Many tools to Union-Summarise-Table-Layout-Render.

Thanks!

Output

Tips and Tricks

Accepted answers

Kenda

@nausherc The first workflow I attached did not have a grand total row, so I have attached an updated workflow that contains all the subtotals and the grand total.

Is this what you're looking for?

nausherc.yxmd

All comments

Kenda

Hey @nausherc!

Have you tried the Running Total tool and grouping by your Class field?

nausherc

Hi BarnesK,

Yes, I tried that as well. But the totals are continuous and calculated at columns, while I am looking to use rows.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703