Master Calender and difference between same columns/rows of atwo diff tables

[ankit_tikoo]

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