Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
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