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.
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.
Hi,
I seem to have a similar situation to add totals but I am not able to open this sample file because I am on an earlier version of Alteryx
10.6.8.17850.
Any suggestions?
Thanks!