Hello Community,
I have to add up values in a column based on a specific parameter. For example:
MARK 15
MARK'S COMPUTER 20
JENNY 60
JENNY'S PHONE 12
I want to create column's Mark's Total and Jenny's Total adding up the specific amounts, how do I do this?
Thanks!
Please see below :
1- RegEx to take the name
2- Aggregate on the new column and SUM
Attached the workflow,
Hope this helps!
Regards