Set direction for single relationship

[apohl1]

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 · Accepted solution]

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. :