Alteryx Assistance: Category Row Insertion, Contribution calculation & Excel formating

[RaviPM10]

Hi Team,

I require assistance with an Alteryx workflow. Specifically, I need to

1. Insert row after each category based on output file

2. Perform Contribution calculation using total MV

3.output the result in specific excel format

for reference I've done the calculation in attached Sum calculation file kindly refer to "Output Tab"

Thanks

[OTrieger · Accepted solution]

@RaviPM10 
If you will build 1 WR and save it in a Batch Macro, Control Parament will be the different categories.
Set a Mapping file to rename the elements, then sum them up you will have a tool for each element, create Total and % and add the sum for each category and add a blank row under it, and then connect it to the Batch macro output.
You will get what you are trying to get. You can use Blob Tool to write the data into specific ranges that been designed as per your format.

[RaviPM10]

Hi @OTrieger , do you have any sample workflow my reference.