Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Add a 'Total' Row

malafollette
6 - Meteoroid

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

10 REPLIES 10
Aaron_Harter
11 - Bolide

@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

afv2688
16 - Nebula
16 - Nebula

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

ktberger_2020
7 - Meteor

Does anyone know if there is a way to format and name the "Total" row?

ktberger_2020
7 - Meteor

I apologize, what I was looking for was for the totals to show up as the bottom row. Something like this scenario: 

 

Store #Field1Field2
ABC$5,465.00$546.00
DEF$8,956.00$5,878.00
GHI$4,654.00$321.00
JKL$546.00$6,859.00
MNO$231.00$562.00
123$24,857.00$33.00
STU$132.00$648.00
VWX$3.00$61.00
YZA$27,498.00$3.00
BCD$4.00$34.00
EFG$3,215.00$346.00
Totals$75,561.00$15,291.00
nihou
8 - Asteroid

@ktberger_2020 did you get solution you were looking for? I am looking for the same scenario so wanted to check with you first. Thanks!

ktberger_2020
7 - Meteor

No, I was shown how to get the figures totalled but I never found how to get the text "Total". I've just resorted to leaving that cell blank and putting the figures in bold and relying on the audience to figure out that it is the total line. Not ideal for me but so far I have not had any problems going this route.

CarliE
Alteryx Alumni (Retired)

@ktberger_2020 

 

Take a look at this post

 

You can use a formula tool to name a column total if its empty or null.

 

I can build it out for you too.

 

Carli
CarliE
Alteryx Alumni (Retired)

@ktberger_2020 

 

Attached.

Carli
ktberger_2020
7 - Meteor

@CarliE  That's perfect. It does exactly what I was looking for and it's nice and easy!

 

Labels