Forum Discussion
Combining/Merging columns with different data and quantity
hi KJ_YG
You need to manage the relationship between the primary keys in the table.
To do that, go to model view and add a new relationship like below:
Once you do that now you can add a matrix in the order you need to get the output.
I simulated your scenario and got this:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hi KJ_YG
You need to manage the relationship between the primary keys in the table.
To do that, go to model view and add a new relationship like below:
Once you do that now you can add a matrix in the order you need to get the output.
I simulated your scenario and got this:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thany you so much for your help. However, it would be better if i were to create a 1 to 1 relationship between my PO tracker and tracking PO values. Why is it not possible to create a 1 to 1 relationship between them?