I have a list of sales leads which has a Buisness Area assigned to each lead. I want to EVENLY distribute to leads to the sales people in the same Business Area.
Let's say I have 15 leads in BA-1 and 6 sales reps assign to BA-1.
How can I assign the leads to the 6 sales people evenly. In this example each should recieve 2 leads and 3 reps would get one more each. Next time the leads come in the 3 reps that ere 1 short last time would recieve the first 3 leads.
Not even sure this can be done.
Thanks for time.