I have the following problem.

I have a sample of people say 5 people as shown below, with information on some behavior of theirs, lets say purchases made by them at store 1, store 2, store 3. I also know how much in dollars each store sold to all its customers, say store 1 sold a total of $5000 of merchandise, store 2 sold $10,000 worth of merchandise, etc. i don;t know how many people bought $5000 worth merchandise, all I have is the $5000 amount.

I need to create weights so that the sum of weights for persons that bought at store 1 equals $5000, sum of weights for persons that bought at store 2 equals $10,000, etc. I am not able to figure out how to do this using rim weighting or raking since the metric i am trying to weight is not persons but behaviors ie., volumetric data. Any help or ideas appreciated. Thank you so much.

persons purchase at store1 purchase at store2 purchase at store3

1 $0 $100 $20

2 $100 etc

3 $24

4 $0

5 $90