Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

joining tables and creating report using Matrix visualization

I have two tables as below   table1 PK1   PK2   name    states     age     a b AM arizona 5 a b AM cali 5 a b AM ny 5 a b AM nj 5 a b AM wy 5       ...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Do you think that the below view is possible? I am not sure how to perform the join as in the first table PK1 occurs multiple times but in the second table PK1 would be there only for 1 time. I dont want to repeat the salary multiple times.

 

v-deddai1-msft's avatar
v-deddai1-msft
Community Support
6 years ago

Hi Anonymous ,

 

Is the screenshot below you want?

 

Just close the stepped layout and icon of row header and put states in the last filed of row:

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai