Hi, I have a list of accounts and their sales, I need to divide the list into 2 separate lists with similar revenue totals, and #accounts as possible. What is the best way to achieve this?
Please provide some sample input data and desired output. Your query isn’t specific enough for anyone to help yet
Absolutely see below. So the # of accounts in each list is similar, and the distribution of revenue in each list is close as well