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.
Solved! Go to Solution.
@ferha_jafri
Hope I get you correctly.
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 : )
Hello atcodedog05,
Yes correct I am looking for this output with a slight change in Total Sales I want sum of total sales number.
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.
@atcodedog05
Nice one as usual.
@ferha_jafri
You can choose to output the Excel by specifying a path and Excel format.
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.