Dynamically Sum Values in Columns

[taschmies]

Hi all,

I'm trying to find a way to sum the values across multiple columns and group by people's names, as well as show a grand total for each column. The names are in the left most column, and any number of following columns will be numeric and populated with a numeric value. I need to dynamically sum across all the columns and display a total for each person, as well as a grand total for each column at the bottom. The values are representing each person's capacity of work hours for a given week. The weeks will change so I need to be able to sum for any number of columns with any given name, but they will all be numeric.

I am attaching a screenshot of what the end result should look like as well as an example workflow. Thank you in advance for any help!

[binuacs · Accepted solution]

@taschmies if you are using the cross tab tool then there is an option to calculate the row total and column total