Forum Discussion

fahadarshad's avatar
fahadarshad
Helper I
9 years ago

problem with reporting on multiple relationship

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?

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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