Gap between actual and target in matrix table

[yh1978]

Hello everyone
I am trying to build a matrix report based on 3 tables
which calculates the actual compared to the target.
It totally messed me up.
I would appreciate it if someone could help me with this.
Thank you

[v-nuoc-msft]

Hi @yh1978 

Try the following:

Create tables relationship.

Create a visual.

Here is the result.

Regards,

Nono Chen

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

[yh1978]

Hey
thank you very much for your answer.
I did everything according to your recommendation.
Everything is going fine until I add meazure which calculates the gap between the actual sales and the target sales.

[bhanu_gautam]

What is the exact requirement and where are you stuck can you elaborate

[yh1978]

Hey
Let's start with the first problem
When I bring the data of targets to the matrix table, duplicates are created. I want each client to have one line with the actual sales against the targets.
Thank you