Output data... Two outputs to one Excel tab and data is side- by- side

[lisamccullough]

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

[JagdeeshN]

Hi @lisamccullough ,

Can you please provide some sample input data you are working with.

Best,

Jagdeesh

[lisamccullough]

Sure. Please see the attached.

[HomesickSurfer · Accepted solution]

Hi @lisamccullough 

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

[lisamccullough]

Thank you! This worked like a charm. 

Any idea how I can add in subtotals and totals to the Double strings?

[atcodedog05]

Hi @lisamccullough 

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?

[HomesickSurfer · Accepted solution]

Hi @lisamccullough 

Here goes..workflow attached. .calculated and laid out your June data...apply same for your July.

The canvas isnt too pretty...but works.

[atcodedog05]

Awesome @HomesickSurfer 🙂👍

[lisamccullough]

Thank you so much! It works!... You're kindof a superstar.. Alteryx style...

[HomesickSurfer]

@lisamccullough  Thx! 🙂

I'm pleased it works for you!