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!

Fruits.xlsx

apathetichell

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.

total fruits again - corrected.yxmd