Hello Alteryx Guru's,
I am trying assign demand to the supplier who have least price, if the least price supplier doesn't have enough capacity to produce allocated demand and the rest of the demand has to allocate to the next least price supplier until demand is fully allocated. Demand = capacity
After allocating to all the suppliers if still demand remains, it should be named as unassigned
Under each Group their are many Countries and in each country has many Suppliers, the load has to assign to the suppliers who have least price ( 1st preference to the least price and assign max to his capacity and rest to the next least priced) in each countries
I tried using Multi-row formula but could not achieved expected output.
I have attached sample data with expected output.
Can someone help me here
Thanks in advance
