Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Output in a desired format

ferha_jafri
8 - Asteroid

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.

 

 

7 REPLIES 7
Qiu
20 - Arcturus
20 - Arcturus

@ferha_jafri 
Hope I get you correctly.

Capture2A.PNG

atcodedog05
22 - Nova
22 - Nova

Hi @ferha_jafri 

 

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

 

atcodedog05_0-1620284976851.png

Workflow :

atcodedog05_1-1620285007638.png

Hope to hear back from you.

Have a good day : )

ferha_jafri
8 - Asteroid

Hello 

 

atcodedog05
22 - Nova
22 - Nova

Hi @ferha_jafri 

 

Something like this 

atcodedog05_0-1620286327592.png

 

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

ferha_jafri
8 - Asteroid

To 

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
20 - Arcturus
20 - Arcturus

@atcodedog05 
Nice one as usual.

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

Qiu_0-1620299440481.png

 

ferha_jafri
8 - Asteroid

To 

 

Labels