Hi, what is the best way to include in the last row a total of every column.
| a | b | c |
-------------------
| 1 | 3 | 5 |
-------------------
| 3 | 5 | 6 |
-------------------
total | 4 | 8 | 11 |
Thanks in advance for the help.
Regards
Solved! Go to Solution.
@jdunkerley79 might be right, but I don't have that tool loaded.
Here is a module that will remember the column order, dynamically select all numeric columns and will create a total for them. It blends the data together.
His answer is probably better, but here is an approach that might work for you too.
Thanks,
Mark
Thanks for your help, but when i try to open de project give me and error that i attach,
Good point - its actually a CReW macro.I didn't notice - my Alteryx is quite customised these days....
You can grab the macros from here http://www.chaosreignswithin.com/2015/10/crew-macro-pack-2015-q3-release.html
Using standard tools you could do something like the attached. (though I like @MarqueeCrew solution too).
Not sure if this will handle nulls in the data very well!
Fixed for nulls
Thanks both, is working now.
You can also use the "Summarize" tool. Set each column to SUM and don't provide a Group By. You can then UNION the new "total" row back to the original data set.
I got the totals row added (thanks everyone!). Is there a way to name the last row as "totals" in my table?