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.

Creating Subtotal For Each Column.yxmd

Kenda

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!