Add Each Row and sum the value in new column

[adarsh2608]

Hello,

How to sum the entire row in alteryx and create new TOTAL column at the end and total value is added over there. In the first screenshot is the data and second screenshot is the expected output created with total

[IraWatt · Accepted solution]

Hey @adarsh2608,

Here is how I would achieve this:

Any questions or issues please ask :)
HTH!
Ira

[adarsh2608]

@IraWatt , Thank You this was helpful

[IraWatt]

No worries @adarsh2608 ! glad it helped :) 

[binuacs · Accepted solution]

@adarsh2608 One way of doing this using the cross tab tool. I added the column total and row total as well