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

Alteryx.xlsx

Workflow

Accepted answers

MarqueeCrew

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

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

Cheers,

Mark

All comments

MarqueeCrew

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

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

Cheers,

Mark

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?

Solution Totals.yxzp

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!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703