ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com 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.
解決済み

Sum of columns

ajithey
メテオール

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件の返信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
マグネター

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

yalmar_m
ボリード

What about this solution?

ajithey
メテオール
Hi,

This is my output file

But I only need to add a total line
ajithey
メテオール

@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
クエーサー

CreW Macros - THE BEST FOR THIS!

 

 

J

ラベル
トップのソリューション投稿者