Creating a sum on each row for the data from Column B to Z.

[kariinaracampbell]

[Luke_C]

Hi @kariinaracampbell 

Here's how you can do this:

1. Transpose the data. This is what will make this process dynamic, it will turn your month columns into rows. Since the unknown fields box is checked, any new months added will also be handled.
2. Summarize the data by employee. This produces the summed amount
3. Join the sum back to the original dataset. Here I have moved the 'unknown fields' box before the sum, so it will always be the last column.

[Jonathan-Sherman]

You could actually also achieve the same result without the join! As @Luke_C has done transposing the data, we could instead then crosstab it back (from row labels to column headers) but also ticking the total column in method for aggregation alongside sum (as seen below).

Ticking SUM method for aggregation:

Ticking Total Column method for aggregation:

Kind regards,

Jonathan