Free Trial

Alteryx Designer Desktop Discussions

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

create row to sum total of each column

Camiiara
6 - Meteoroid

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

 

 

50

b

blue

100

50

 

150

c

brown

 

 

25

25

d

yellow

 

100

 

100

e

pink

5

10

 

15

f

black

 

 

 

0

TOTAL

 

155

160

25

340

 

Thank you so much for the help! 

3 REPLIES 3
cmcclellan
13 - Pulsar

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

flying008
15 - Aurora

Hi, @Camiiara 

 

there is a workflow for you reference:

 

录制_2022_09_22_17_00_10_159.gif

 

*********

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

Emmanuel_G
13 - Pulsar

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

 

Emmanuel_G_0-1663836272701.png

 

Labels
Top Solution Authors