problem with reporting on multiple relationship

[fahadarshad]

hello 

I cannot seem to grasp this issue.

here is my relationship model 

The problem is that when I pick up the revenue from the relatiohsip table and match it against targets in goals table, depending on the where I pick the user name from (user name in system users table or opportunity owner from opportunities table) one of the two values (either revenue or target) duplicates itself.

how can I match up for each user their revenue and targets?

[v-shex-msft]

Hi @fahadarshad,

>>depending on the where I pick the user name from (user name in system users table or opportunity owner from opportunities table) one of the two values (either revenue or target) duplicates itself.

I'd like to suggest you change the "corss filter direction" option to "both" and try again.
In addition, if you want to use username to filter other data, you should check the "username" and make sure it not contains the duplicate value.

Regards,

Xiaoxin Sheng

[fahadarshad]

Need assistance with this please

[fahadarshad]

still stuck on this...need assistance please