Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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
dataguyW
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
Top Solution Authors