Scenario likes this:
Dimension#1 Year Target Fulfillment Percentage
Dimension#2 Discount (Selling Price/ List Price) for each transaction
Ratetable is based on the two dimensions.
So the formula is like this:
Individually, no accumulative
Input1: Year Target Fulfillment Percentage ( How to achieve this?)
Input2: Discount (Easy to do)
Is there anyone has any thought about it? The headache is when calculating the rate for each transactions (different discount), you need to know the whole year Target Fulfillment Percentage.