Good morning.. I am trying to build a workflow where two separate outputs are placed on the same spreadsheet but are beside each other and not in the same columns. Also, I need to include subtotals.
I've attached an example of what the report looks like in Excel and I've attached a copy of the workflow I currently have. I'm able to build out what I need the reports to include... but I'm having trouble include subtotals on the amounts and placing the reports side by side for viewing.
Thanks in advance;
Lisa
Solved! Go to Solution.
Hi @lisamccullough ,
Can you please provide some sample input data you are working with.
Best,
Jagdeesh
To output side-by-side, config your output option to Overwrite Range and specify to write to:
Eg.
C:\temp\Date Entry Output.xlsx|||Sheet1$A2:I43
C:\temp\Date Entry Output.xlsx|||Sheet1$M2:U43
Thank you! This worked like a charm.
Any idea how I can add in subtotals and totals to the Double strings?
Is subtotal and total already present in the data or does it need to calculated? If it needs to be calculated can you tell us how its calculated?
Here goes..workflow attached. .calculated and laid out your June data...apply same for your July.
The canvas isnt too pretty...but works.
Awesome @HomesickSurfer 🙂👍
Thank you so much! It works!... You're kindof a superstar.. Alteryx style...
@lisamccullough Thx! 🙂
I'm pleased it works for you!
User | Count |
---|---|
18 | |
14 | |
13 | |
9 | |
8 |