Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!

SOLVED

Trying to Adding Total For each Column

bmay10
7 - Meteor

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. 

 

bmay10_3-1609260132735.png

 

 

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

 

bmay10_0-1609259670712.png

 

 

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

bmay10_1-1609259908047.png

 

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

 

bmay10_2-1609260002199.png

 

 

 

Kenda
14 - Magnetar
14 - Magnetar

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
12 - Quasar

@bmay10,

 

Please see below:

 

messi007_0-1609262241432.png

 

 

Attached the workflow 🙂

 

Hope that Helps 🙂

 

Regards

bmay10
7 - Meteor

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

bmay10
7 - Meteor

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

ll98
8 - Asteroid

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

 

For example

Fund NameTNACost Value
Fund 1 100020003000
Fund 1200020004000
Fund 2200050004000
Fund 2 100060005000
    

 

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"

 

 

 

 

 

ll98_0-1613666574366.png

 

 

 

 

 

 

 

messi007
12 - Quasar

@ll98,

 

You can acheive this using a batch macro:

 

1- Create a batch macro to calculate the total:

 

messi007_0-1613670953952.png

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

 

messi007_1-1613671110381.png

 

3- Below the result

 

messi007_2-1613671207834.png

 

 

Attached the workflow.

 

Hope this helps,

Regards

 

ll98
8 - Asteroid

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
12 - Quasar

@ll98,

 

Could you share the workflow in order to help you.

 

Best Regrads,

ll98
8 - Asteroid

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

Labels