Consumer bigint (PK)
I want to redistribute records in the above table to 4 different groups (currently not in table X) equally by the sum of the DollarValue (not a record count).
Table X can have up to 5,000 records with a dollar value ranging from $10.00 to $10,000.00
I know the dollar values will never equal across all of the 4 groups, but it needs to be as close as possible.
Redistributing by a total count is easy, but I cannot come up with a good strategy based on the SUM of DollarValue.