create row to sum total of each column

Question

Hi! i need to create a row at the end of the table to sum values of each column. The rows and columns are dynamic, they change every day. I already did the column with totals, but could not do the row with totals (green line).

Please see below an example of what i need to do:

House

color

2-Jan

3-Jan

4-Jan

total

a

red

50

b

blue

100

50

150

c

brown

25

d

yellow

100

e

pink

5

10

15

f

black

0

TOTAL

155

160

25

340

Thank you so much for the help!

Emmanuel_G · Answer

@Camiiara

Find attached a very easy way of doing this.

Let me know if there is any issue and do not hesitate to mark this answer as solution if it helped.

create row to sum values of the columns.yxmd

flying008 · Answer

Hi, @Camiiara

there is a workflow for you reference:

*********

Please mark it as a solution if can help you get expected result.

cmcclellan · Answer

Create a Summarize tool that sums the columns that you're after, then union back to the original file