A Long Description without some workbook leads to Delay in providing Help
Thanks, I fully understand your point, sorry for not having this. I am though asking for help in how to structure the data and an approach than a specific workbook challenge.
Do sections one and three have the Quarter in them as it is in section two? I ask because whether we join them or blend them, we have to have something that ties them together.
The rebate table doesn't have this level of detail as its more a datasource to create the calculation.
I can though shape the structure of this and add if necessary, if I do this at the row level then I would need to repeat the rebate rows for every quarter.