Add additional rows for sum amount

[anhdo92]

Hi

I am looking to add additional rows that show the sum amount by shortnames.

Input (file attached)

For each shortname that shares the same Code, I would like to add an additional row right below to show the sum amount of Volume and Amount.

From there, I would like the workflow to be able to generate separate output files based on shortnames following the format below:

Output file 1:

Output file 2:

Any help is much appreciated!

[apathetichell]

Hi!

do you need the fruit/code subtotals as records or can they be columns in the related records? I know in excel it makes more sense to put the subtotals underneath but in Alteryx, we keep them with their respective records (unless it's a table/report structure).

[anhdo92]

Hi @apathetichell  thank you for your help. 

Yes I do need to put the subtotals underneath so that the output follows a report structure in my previous screenshots. 

Any ideas ? 🙂

[apathetichell · Accepted solution]

This version has the totals added back to the source as new rows with "total" in the shortname field and the codes/sum volumes/sum amounts below.

Corrected version - sum volume/sum amount were aligned incorrectly in the Union in the original.

[Qiu · Accepted solution]

@anhdo92 

Made some further improvement to @apathetichell work.

Add the blank row and also the output option.

[anhdo92]

@apathetichell @Qiu 
Awesome. Thanks both! I managed to find a workaround but your suggestions help simplify my workflow a lot!
Thanks again

[Qiu]

@anhdo92 
Happy to help and thank you for the accept mark. 😁