SOLVED
Add Multiple Columns into single column
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
sshind58
5 - Atom
‎04-12-2024
10:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Solved! Go to Solution.
Labels:
- Labels:
- Custom Tools
- Expression
- Tips and Tricks
3 REPLIES 3
18 - Pollux
‎04-12-2024
10:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Transpose those columns and CrossTab them back (with Sum and Total selected) should do the trick!
18 - Pollux
‎04-12-2024
10:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Roland's solution here should work decently well: Solved: Adding totals to dynamic table - Alteryx Community
‎04-14-2024
06:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you...!!
