Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.
SOLVED

Add a 'Total' Row

Highlighted

Hello, I am trying to add a simple row that will total my "Amounts" column in my output. What's the best way to do that? I've attached pictures. The highlighted box is where I need a total.. Any ideas?

 

 

Alteryx Total.png

Highlighted
Alteryx Partner

@malafollette you can accomplish this by using a Summarize tool to calculate the total, then a Union tool to add the record to the bottom of your data set:

1.PNG

Alteryx Certified Partner
Alteryx Certified Partner

Hello @malafollette,

 

You can do it easily with a union and a summarize tool. Just remember to change the name from the summarize output to match to the column where you want to show the total.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

Labels