Using alteryx for aggregation

[aeolus187]

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?

[messi007]

@aeolus187,

Please see below 

Attached the workflow,

Regards,

[grazitti_sapna · Accepted solution]

Hi @aeolus187, try this.

Thanks!

[aeolus187]

@grazitti_sapna 

thanks for your solution awesome

[grazitti_sapna]

@aeolus187 , Glad it helped!