Subtotals/Grand Total with Keeping a Template

Question

I need some help with getting numerous subtotals and then a grand total on about 10 subtotals. I need the format to essentially be the same, so I've ran into problems with the Summarize Tool.

This is my data I pulled from Alteryx and added subtotals in with Excel. It groups together by the _CBSL1, then by the _WBS L3. Then all _CBSL1 would need the subtotals added together.

My Alteryx workflow is pretty basic, but my data is correct, just without the subtotals.

dataguyW · Answer

I try to follow the data first, formatting second approach on most of these.   I would add summary tools to get the correct level of subtotal/grand totals needed and then use a UNION tool to push the data back together.   You may need to create a field to help with sorting (make it numeric) and then sort the output as desired.