Hai
I have tried very basic of data model that I added 3 tables to data model. By using pivot from data model what I need to get is "Sal" & "Prof" corresponding to "Name" in table 1. But instead am getting a table of all possible combinations. I even tried by creating relation with different directions using "Emp id" but result is same. Actually have to work with multiple tables but now Kindly help me with the basics. My relationship view's ss has also attached
