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.

[Kenda · Accepted solution]

Hi @bmay10 

I applaud you for the work you've done. You're very close! I would suggest naming all of the fields in your totals row the same as the rest of the data stream (e.g. the value total will go in the Store field, the sum of January will go in the January field). That way, when you use the union tool, all of the fields will be matched up correctly automatically. Finally, you'll want to ensure in your union tool that the order is specified that your data stream is first then your total row.

Hope this helps!

[messi007 · Accepted solution]

@bmay10,

Please see below:

Attached the workflow 🙂

Hope that Helps 🙂

Regards

[bmay10]

Thanks for the suggestions. It was very helpful and it did get rid of the extra columns with the word Sum_.

[bmay10]

Thanks cause I was trying to add in Total under the "Store" column. I looked at your changes and it worked. 

[ll98]

Hi - -I have the same question -- where by I can create totals but based on a Column name.

For example

Fund Name	TNA	Cost	Value
Fund 1	1000	2000	3000
Fund 1	2000	2000	4000
Fund 2	2000	5000	4000
Fund 2	1000	6000	5000

I need to create the Totals for each Fund Name and create a file for each of the Fund Name. 

I'm able to create a file for each of the fund name but the total is not coming across to the output file

Using this for the formula "Total". Which is added in the Fund Name column of the formula tool

"Total"

[messi007]

@ll98,

You can acheive this using a batch macro:

1- Create a batch macro to calculate the total:

2- Call the macro and update the output file in order to take file name from path:

3- Below the result

Attached the workflow.

Hope this helps,

Regards

[ll98]

Thanks -- I'm not a batch macro expert yet --- however, I was able to create a total per fund -- however when it create the file document it excludes the Total Row........ It displays correctly on the canvas but on the actual file created does not create the "Total" row.  

[messi007]

@ll98,

Could you share the workflow in order to help you.

Best Regrads,

[ll98]

@messi007   - Sure -- let me masked some of the information