Separating Data

I need to eventually create a YTD report with the following information, sorted by customer number and invoice number.

Here's my situation: If a customer is a current customer, their income amounts show up in the current customer column, and the commission on that amount is calculated based on all current customer income amounts added together, and then compared to a sliding scale. I have this working. If a new customer's income (for all their combined invoices) is <=200,000, I need to list the income for each of those invoices in a separate column for new customers. Once that customer's total income reaches 200,000, I need to display the income in new customer column up to that point, then any income over 200000 needs to be displayed in the current customer column. So if the amount 200,000 is reached in the middle of an invoice, part of it needs to be displayed in the new column, and part in the current. Also, the amount over 200,000 now needs to be added to the grand sum of all current customer income. I show a sample table below - any help would be greatly appreciated.

Code:Cust # Invoice # Current New123 6543 $235,000 432 7435 $150,000432 4685 $16,000 $50,000