data multiplexing

[cantemel]

Hello everyone,

I have 2 tables, one of them contains store code, sales amount, sales amount, year and month data between 2021 and 2023.
My other table contains store code, target, year and month data between 2021 and 2023.
I associate these two tables with the store code. However, while the store's sales amount is correct, the target is incorrect.
I did a lot of research on why but I couldn't find it. Can you help me with this?

Thank you good work