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
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
I'd use the Add Totals tool!
Attached a sample
@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,
Hi,
I know this is quite old now - but it didn't quite solve the issue I was having.
A solution that doesn't use the Total All tool:
Running Total tool on all fields, use a Sample tool to take only the last record to a dynamic select where LEFT([Name],7)=='RunTot_', then a dynamic rename to remove the RunTot prefix.
This works for any number of fields and saves having to input every field into a summarize tool - I had over 4000 fields which I needed to sum.
