We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

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
14 - Magnetar

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