Add a 'Total' Row

[malafollette]

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?

[Aaron_Harter · Accepted solution]

@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:

[afv2688]

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]

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

[ktberger_2020]

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

Store #	Field1	Field2
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]

@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]

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]

@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.

[CarliE]

@ktberger_2020 

Attached.

[ktberger_2020]

---

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

---