Forum Discussion

apohl1's avatar
apohl1
Icon for Helper II rankHelper II
4 years ago
Solved

Set direction for single relationship

Hi all,

Does anyone know why I'm not able to set the direction of the relationship between "Customer aggregation" table and "Raw data: sales" table in the 1st printscreen below (direction should be "Customer aggregation" filters "Raw data: sale" table)?

 

"Customer aggregation" table has only unique values and "Raw data: sales" table has many values. The reason why I want the direction this way is beucase I want "Customer aggregation" to be filtered based on same criterias as the "Raw data: sales" table.

 

Please see 2nd printscreen for the relationship I would like to se t up. When applying it the direction of the relationship always change to "Raw data: sales" table filters "Customer aggregation" and I don't understand why.

 

Thank you in advance!

 

 

 

  • ValtteriN's avatar
    ValtteriN
    4 years ago

    Hi,

    I am pretty sure you cant do what you are describing in a 1:* relationship. As a workaround you could change the relation to *:* and use single direction filtering. E.g. :

     



1 Reply

  • ValtteriN's avatar
    ValtteriN
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi,

    I am pretty sure you cant do what you are describing in a 1:* relationship. As a workaround you could change the relation to *:* and use single direction filtering. E.g. :