Output in a desired format

[ferha_jafri]

Hello Experts,

I am looking for a solution in which Alteryx workflow generates the Inline data and on the same excel I have to add a Summary sheet where at the top I want to have Total sales, Sales for Low and High Flag above the headings.

Below I want Country Name which should appear only in the top row and then State wise Sales for Low and High Flag.

PFA with the sample data and the format I am looking for the output.

Thanks in advance.

[Qiu]

@ferha_jafri 
Hope I get you correctly.

[atcodedog05]

Hi @ferha_jafri 

Are looking for something like this. If yes i can give you a run down of what i did.

Workflow :

Hope to hear back from you.

Have a good day : )

[ferha_jafri]

Hello atcodedog05,

Yes correct I am looking for this output with a slight change in Total Sales I want sum of total sales number.

[atcodedog05 · Accepted solution]

Hi @ferha_jafri 

Something like this 

If not please provide a expected output so that i can match it.

[ferha_jafri]

To atcodedog05

This is exactly I am looking for but how can I send it to the excel through output tool as I have to save the file to a path for users access.

Thanks.

[Qiu]

@atcodedog05 
Nice one as usual.

@ferha_jafri 
You can choose to output the Excel by specifying a path and Excel format.

[ferha_jafri]

To Qiu,

Thanks but the issue which I have is that I have to update the same file through 2 output so through this option I am not able to send it to the same excel with different name.