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 ...