Hi,
Thank you for coming back...
Basically I have a target volume per region like below....and each region will have weight, scores and deciles. Don't worry about decile etc , as long as I can get to the volume I need (sum of weight) that would be good....if I do a cumulative sum of weight, it doesn't work...but summing them up randomly I could reach almost my target. It doesn't have to be 100% match, as long as it is very close. Thank you
Region
Target Volume (Sum of Weight)
East Midlands
11,939
East of England
14,070
London
12,791
North East
7,829
North West
12,933
Northern Ireland
0
Scotland
14,945
South East
17,597
South West
14,511
Wales
5,704
West Midlands
14,890
Yorks and the Humber
10,526
Total
137,735
... View more