I've tweaked a few things which may help someone provide an answer to my problem here...
My 'Targets' table now contains data at Date level which matches my actual data.
I'm still confused about the most efficient way to tie this target data to my actual data though.
My 'Targets' table contains
data for each KPI we are tracking (LEAD_COUNT, SET_COUNT, SAT_COUNT, INSTALL_COUNT, INSTALL_REV, SALE_COUNT, SALE_REV)
the DEPOT for each of these KPI's (which needs to be associated with DEPOT in MainJob so I can filter on just this DEPOT field for both actual and target)
the DATE for each KPI (which needs to be associated with the CommonCalendar and each KPI calendar) so that I can select a Week from CommonCalendar and it group both the actual and target data for that week.
If anyone can give me some guidance (I'm not sure generic keys will work in this instance) this would be much appreciated.
If its easier to attach a copy of my qvw then let me know.