Data calculation

[wendyzjy]

Hi,

There's a calculation questions hope to get your help~

input table is on the top, and expect result is on the bottom

i have already got the above table in alteryx, wondering how to get the bottom table? a sample is attached in excel. 

[atcodedog05]

Hi @wendyzjy 

Here is how you can do it.

Workflow:

Hope this helps : )

[wendyzjy]

thanks a lot on the workflow, it does lighted my mind, run with erros in the filter tool though....

[atcodedog05 · Accepted solution]

Hi @wendyzjy 

Here is the updated workflow try this

Hope this helps : )

[wendyzjy]

This is exactly what I want. Thanks a lot! @atcodedog05 

[atcodedog05]

Happy to help : ) @wendyzjy 

Cheers and have a nice day!