Im sure this is a simple fix however I feel like I just cannot fiugure is out.
I have 4 MAIN TABLES
1) CT TABLE holds all the Information about a COM TECHNICIAN including which TEAM they are in.
2) MEASURES - this table holds CT Fee for Service and Lead Transactions with a Date.
3) % APOINTMENTS MET - is a Table that Holds Values and a Date but at a TEAM level - Every CT that should Inherit these Values.
4) TARGET - This is a Table that contains the TARGETS for each of the Measures at a TEAM level with a Date.
I need to be able to have the TARGET / % APOINTMENTS MET / MEASURES TABLES WORK USING THE master calendar AND ROLL UP TO THE CT TABLE ACCODINGLY - EITHER AT A TEAM LEVEL OR AT THE CT LEVEL.
CANNOT SEEM TO HAVE ALL OF THE ABOVE AT ANY GIVEN TIME.
NOT SURE WHAT I AM DOING WRONG - ANY HELP OR POINTING ME IN THE RIGHT DIRECTION WILL BE MUCH APPRECIATED.
PLEASE SEE DATA MODEL ATTACHED.