Using alteryx for aggregation

Hi Alteryx engineer,

I have data like below column are dynamic, there might be 5 ,6 or more

and i want to sum quantity at the last row and get something like this, any thought?

Help

Accepted answers

Hi @aeolus187, try this.

Thanks!

Please see below

Attached the workflow,

Regards,

Prime Analytics loves Alteryx.png

Hi @aeolus187, try this.

Thanks!

thanks for your solution awesome