Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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

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