Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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