I have 5 bands of commissions for sales based on customer consumptions.
I receive historic analysis of cutomer consumptions based on customer deciles
I want to be able to calculate the commissions I will pay for my forecast next quarters sales based on the historic consumptions.
How can I get around the incompatible range sets
I have attached a sample of the data involved. (the ranges are not constant and the number of commission bands can change)