Till column 4 data from Table1, column1 , column2,column3 taken as key from Table 1 , Table2, Table3.
column4 value should match with Test1,Test2 or can be null. Table 2 and Table3 one field name is similar which contains the above values mentioned in the Test1 teast2. Alias field name1 & field name2
From Table 2 :Tast1 chart condition applied : if (sum(num( column4)=sum(num(field name1),field name1)
From Table3 :Tast2 chart condition applied : if (sum(num( column4)=sum(num(ffield name2,field name2)
I just wanted to show the missing value in the test1 and test2 corresponding to column4
