I have a "Owners" list and a "Metrics" list.
In "Owners" list, each owner has a individual record created for him.
In "Metrics" list,each owner has multiple records assigned to him. In each record,the owner updates a metrics column
In "Owners" list,I want to trigger a workflow for each owner.The workflow should sum up values in the "Metrics" column in "Metrics" list for every owner.The sum should be updated back in "Owners" list for every owner.
How can this be achieved? I tried Looping with SP Designer 2013 workflow ,but that doesn't seem to be working. Looping runs through only one item in the "Metrics" list.