Sum Columns

[NBPSE]

I have a list I want to keep sorted Ascending (Alphanumeric sorting, 1A, 1Z, 2A, 2AT, etc), but I also want to sum the columns relating to those classifications. For example, Column 'Tree' has values for each row, and sums to $100. I can't seem to keep my alphanumeric sorting in order, and move my total values (created using SUM tool and then a join) to the end of my list of rows. What is the best way to sort my rows in ascending order, and output the Totals of the columns at the bottom of my list?

[OllieClarke]

HI @NBPSE 

you'll probably want the combination of a union and sort tool (with a calculated sort column). It will be easier to show you if you share some example data

[Raj · Accepted solution]

@NBPSE 
find the workflow attached
hope this helps mark done if solved

[NBPSE]

Thank you for taking a look. I meant 'union' instead of join. That wasn't working for my data.

[NBPSE]

Thank you for this, it looks promising. I will try this and let you know how it goes.

[NBPSE]

This worked, thank you! Would you do something similar to this for totaling multiple columns?