Data calculation

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.

Accepted answers

Here is the updated workflow try this

Hope this helps : )

Here is how you can do it.

Workflow:

Hope this helps : )

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

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

Happy to help : ) @wendyzjy

Cheers and have a nice day!