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

Question

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

Sum Calculation.xlsx

OTrieger · Accepted Answer

@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.