Power,
I'm still unclear because your example didn't make sense to me. Nov shows $20,000 in last month and $14,500 in this month. But on your Dec total line, you show $30,000 in last month and $20,000 this month. Wouldn't last month - which is Nov - be $20,000?
Are you saying that any given month's commission rate is based on the current month sales combined with the last month's sales? Or are you saying that it is an accumulative YTD thing, for example, in November, you would combine Jan - Nov sales to figure out the rate?
Cathy