Alteryx Designer Desktop Discussions

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

Sum of columns

ajithey
7 - Meteor

Hi,

 

Need your help.

 

I want to know how I can have a row called "Total" which should be sum total of multiple columns I have.

 

I have attached my output and the fields in yellow is what I need.

 

I tried using Running total but it appears as columns. Also did transpose to running total but was not a success.

 

Thanks for your time in advance and have a nice day

6 REPLIES 6
MarqueeCrew
20 - Arcturus
20 - Arcturus
You need a CReE macro, create Totals. You can download them here:

http://www.chaosreignswithin.com/p/macros.html?m=1

Cheers,

Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
cmcclellan
13 - Pulsar

What does your input look like ? Is it just this file without the total and you want to add the total line ?

yalmar_m
11 - Bolide

What about this solution?

ajithey
7 - Meteor
Hi,

This is my output file

But I only need to add a total line
ajithey
7 - Meteor

@MarqueeCrew wrote:
You need a CReE macro, create Totals. You can download them here:

http://www.chaosreignswithin.com/p/macros.html?m=1

Cheers,

Mark

Thank you Mark, great help indeed!

jacob_kahn
12 - Quasar

CreW Macros - THE BEST FOR THIS!

 

 

J

Labels