Hi All,
I need your help in two issues:
1. I need to link date fields of two separate tables to a master calender. The two tables will be created from same data with diff columns haedings
2. Once this is done. I will create chart tables using both tables separately as below:
Chart table 1: This actually contains the situation at a date L1
Salesperson Name A+ Client B+ Client C+ Client
Job Smith Yes Yes No
Ashton Jones No Yes Yes
Lara Janes Yes Yes Yes
Chart table 1: This actually contains the situation at a date L2, which is more recent than L1
Salesperson Name A+ Client B+ Client C+ Client
Job Smith Yes Yes No
Ashton Jones Yes Yes Yes
Lara Janes Yes Yes Yes
I want the below table:
Salesperson Name A+ Client B+ Client C+ Client
Job Smith NA NA NA
Ashton Jones +ve NA NA
Lara Janes NA NA NA
Total 1 0 0
Wherever there is a change in status at L2 as compared to older date L1,
1. If it changes from Yes to Yes, show NA
2. If it changes from No to No, Show NA
3. If it changes from No to Yes, show +ve
4. If it changes from Yes to No, Show -ve
So, I want to populate 3rd table on basis of first two tables. I also want to add positive changes for all salespersons to rate their performance.
Thanks