Subtotal rows

[dottman]

Hello - wondering if somebody could help create a column on the far right that subtotals the values to the left? Would appreciate it!

[alexnajm]

If you want it to be dynamic, I put do a Transpose (Key Column = Size, Data fields = everything else) followed by a CrossTab (Group By Size, Change Column Headers to Name, Values to Value, and Aggregation as Sum AND Total Column.

[alexnajm · Accepted solution]

If you want it to be static, a Formula tool would work to create a column that is simply the column of all of the columns you need.

[dottman]

Static will work - appreciate the help.