Row level Summary for changing columns

[praneshsapmm]

Hello ,

Can someone help me to solve below requirement . 

I would like sum the values from different columns using summarize tool as show below : 

A	B	C
1	1	1
2	2	3
3	3	4

I could do that , but at times the input columns will be changed and i had to modify the workflow everytime to sum the new columns as shown below :

A	D	C	E
1	1	1	1
2	2	3	3
3	3	4	5

Is there any workaround to summarize for dynamic columns . 

Thanks

[DataNath]

@praneshsapmm the usual approach to dynamically total fields is to Transpose the data, bringing the headers and values into the dataset. After that, we can then re-Cross Tab the data and one of the options when doing so is to create a Total Column. After that, it's just some clean up of the names and removing the grouping field created in the Tile:

End result:

You can see that if we add the second example you provided, the workflow works fine without any changes needed:

[JamesCharnley]

Hi @praneshsapmm 

If you transpose before the summarize and group by name it'll sum them all