Total Column

[skrsanac]

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

[DanFlint]

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.

[SI]

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!