I would like to insert a rolling monthly target into a table for each location. e.g. Location 1 - monthly target is 5. First of the financial year equals 5 then the next month add another 5 which equals 10.
Jan - 5
Feb - 10
March - 15
April - 20 and so on.
Location 2 - monthly target is 7 so,
Jan - 7
Feb - 14
March - 21
April - 28 and so on.
For each of my locations I have been able to create the weekly target and FY target to show in the table but I would like to insert a monthly target in the table to measure total numbers against a rolling monthly target.
This my table now with the FY target inserted. I want to remove the FY target and insert a monthly rolling.
