Add Multiple Columns into single column

Hello Dears,

I have columns with c1,c2,c3,c4,c5 headers and I want to add values from them in single column "Sum C". Currently I am using formula tool, but for that I am entering all formula manually like c1+c2+c3+c4.. I have 30-40 columns and also need to add many such Sum columns. Can anyone please suggest shortcut for this?

Tips and Tricks

Custom Tools

Expression

Accepted answers

Roland's solution here should work decently well: Solved: Adding totals to dynamic table - Alteryx Community

All comments

Transpose those columns and CrossTab them back (with Sum and Total selected) should do the trick!

Roland's solution here should work decently well: Solved: Adding totals to dynamic table - Alteryx Community

Thank you...!!

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15867

MarqueeCrew 13708

apathetichell 13703