Output in a desired format

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.

Output Sample.xlsx

Preparation

Accepted answers

atcodedog05

Hi @ferha_jafri

Something like this

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

report format.yxmd

All comments

Qiu

@ferha_jafri
Hope I get you correctly.

New Workflow2A.yxmd

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 : )

report format.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703