Sum in excel sheet

[Kjaer]

I have a case, which make the wanted sheet as attached. Is it possible for Alteryx to make a sum of the three columns?

Best regards

Thomas

[OTrieger]

Hi @Kjaer 

Yes you can, still not sure what exactly is needed. As if you want to get the total for each column than you can use simple Summarize Tool, However if You want to Sum all 3 columns then first you will need to Transpose the data and then Sum them up.

[Qiu]

if 3 columns are fixed, use a Formula tool

If your columns are dynamic, then transpose + Cross Tab

[Kjaer]

Thanks for the answers. I have changed a little in my case and instead inserted a new column. 

Now I also have two sheets.

Is it possible in one way or another to calculate the sum of the two sum-columns?

Please make a model for me if it is possible :-)

Best regards

[TUSHAR050392]

You will have to combine the two datasets together by joining on common field in both datasets. Once data is joined, you can sum the two sum columns by using a formula tool and creating a new column. Hope this helps.