Calculate Sales Tracking against target
Hi I have 2 tables namely the target table and sales table. the target table indicates the resource, with the target and whether it is monthly or annually. When the target is annual, the SUM of sales must be checked against the yearly target. When the target period is set to monthly, then every month the resource must achieve that target, there are no carryovers from the previous month. I need to present how the employee is tracking against the annual and monthly target
