In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Make sure to check your account preferences in my.alteryx to make sure you have filled out your security questions. Learn more here
Start Free Trial

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

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
Top Solution Authors