Sum of the Multiple fields in one new column

[Mr_Brown]

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,

[LordNeilLord · Accepted 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

[Dazzerman · Accepted solution]

Hi Mr Brown,

Here is a module that will calculate the values in the format you're looking for.

I hope this helps!

🙂

[OllieClarke · Accepted solution]

Hi @Mr_Brown, The Cross Tab tool has a 'Total Column' aggregation method which will do what you want:

[Dazzerman]

An even better solution!