Hi
I have an issue with two tables, the linking key is CustId between Table A and Table B. and I created a table chart to summarize the issue.
| table A | Table B | Table B |
| Company | customerId | productId |
| X | Cus1 | Prod1 |
| - | Cus1 | Prod1 |
the two lines have identical values in Table B and since it is the same key that relates the two table it should normally return the first line only.
Can somebody explain this issue?
Thanks for the help
