Hi Team,
I am trying to total 30 columns in the new columns. Further If you could provide the solution apart from expression: "[A]+[B]+[C]+[D]". For example Data is
Input:
Field Name | A | B | C | D |
Rahul | 10 | 15 | 20 | 35 |
Rajat | 15 | 20 | 35 | 40 |
Output:
Field Name | A | B | C | D | Total |
Rahul | 10 | 15 | 20 | 35 | 80 |
Rajat | 15 | 20 | 35 | 40 | 110 |
Your help is highly appreciated.
Regards,
Solved! Go to Solution.
Hey @Mr_Brown
Easiest way is to transpose (grouping on name) the use summarize to sum Value (grouping on name again)
Then you can join your results back on to your original table
Hi @Mr_Brown, The Cross Tab tool has a 'Total Column' aggregation method which will do what you want:
An even better solution!