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!
Solved! Go to Solution.
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 @Qiu
Awesome. Thanks both! I managed to find a workaround but your suggestions help simplify my workflow a lot!
Thanks again
@anhdo92
Happy to help and thank you for the accept mark. 😁