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

[jdunkerley79]

I'd use the Add Totals tool!

Attached a sample

[MarqueeCrew]

@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

[skrsanac]

Thanks for your help, but when i try to open de project give me and error that i attach,

[jdunkerley79 · Accepted solution]

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

[jdunkerley79]

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

[skrsanac]

Thanks both, is working now.

[AricMH]

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.

[SpartanAsh]

I got the totals row added (thanks everyone!). Is there a way to name the last row as "totals" in my table?

[AricMH]

Once you have the Summarize totals, use the "Formula" tool to add a column with "Total" as a value.  You can then Union the Totals back to the data set if the columns matchup.  I put together the attached workflow demonstrating the steps.  Hope this helps.