Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Subtotals/Grand Total with Keeping a Template

JPAEP
7 - Meteor

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. 

 

JPAEP_0-1629378670254.png

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

 

JPAEP_1-1629379274174.png

 

1 REPLY 1
john_watkins
11 - Bolide

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.

Labels