Alteryx Designer Desktop Discussions

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

Create row to sum the column

hegdepavithra10
9 - Comet

Hi,

 

I want to sum each of columns as seen below, but i want them to summed beneath the columns.

 

hegdepavithra10_0-1607026613774.png

 

note: the rows in which the data is present does not have to be restricted to 4 rows only

 

@atcodedog05 could you suggest.

 

Is there a way that this could be done without using a macro.

14 REPLIES 14
Qiu
20 - Arcturus
20 - Arcturus

@hegdepavithra10 
In the filter, you input the columns you want to do sum.

hegdepavithra10
9 - Comet

@atcodedog05  what does the formula do ? Why is it used ?

atcodedog05
22 - Nova
22 - Nova

Hi @hegdepavithra10 

 

Formula tool is just used to add label Total in the last row 🙂

atcodedog05_0-1607060477518.png

 

hegdepavithra10
9 - Comet

Thank you for the help @grazitti_sapna @atcodedog05 @Qiu @echuong1 @WernerE 

Qiu
20 - Arcturus
20 - Arcturus

@hegdepavithra10 
If you think my flow helps, appreciate you would mark it as accept as well.😁

Labels