Trying to Adding Total For each Column

[bmay10]

How do we put the subtotal on a the bottom row?

Here is some info on what I am trying and what I have tried so far.

On the table there is a column for stores, a column for each month, and a column for subtotal.

I have been trying to add a total for each month and the total of subtotal, but instead it creates a new column.

There is an attachment, too that is showing what I I have tried recently with Alteryx. 

Here is a picture from excel, but this  is what I am trying to make it look like on Alteryx. 

Here is a picture of what I tried recently with Alteryx.

After I use Run, this is what I see and this is the closest I got so far.

[ll98]

@messi007   - So what's doing is creating a separate file for the totals only...

[messi007]

@ll98,

Thanks for the shared workflow, however I need a sample data as well in order to be able to run it.

What i suggest you is to create a multi-row formula at the end of the workflow with new column in order to take the fund name on front of the total.

After that you use the created column in order to add it in the file path

and use file path on the output

Hope this helps,

If you share a sample data I'll be able to give you better help.

Regards

[ll98]

Here's a sample data

[messi007]

@ll98 

Here's the workflow that will do the job.

Please mark my answer as a solution it will others 🙂

Regards,

[ll98]

@messi007 

messi -- The file is broken down into separate files which is fine -- but the total for BO Fund III shows up in BO Fund IV.... We almost there

[ll98]

See file output

[messi007]

@ll98,

Please see the attached output.

Hope this helps.

Regards

[ll98]

Thanks Mess - -This will work --- Do I need to keep writing the formula over and over -- if I have more than 2 funds

[messi007]

@ll98,

Yes as you don't want to use a Batch macro 🙂

Don't forget to make it as resolved it will help others,

Regards,

[ll98]

Resolved.