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.
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.