Hello everyone,
currently I'm trying to create a dashboard for our consulting. The following example is just a short view from the data I'm using but since the problem just involves two columns I don't think it's necessary to explain everything.
The main task is that a region manager can see all the sells from his employees and he also shoulld be able to see the sells from the SecondSellerID and there is my main problem. The region manager only see the sells from the main seller. In the visualisations it only shows the sells from the main seller ofc too.
So I have two columns with the following columns:
- DIM_Seller
> Seller_ID
> Name
> ...
- Seller_Sales
> Seller_ID
> SecondSeller_ID
> ...
I created two relationships from DIM_Seller to Seller_Sales. One is from DIM_Seller.Seller_ID to Seller_Sales.Seller_ID and the other is from DIM_Seller.Seller_ID to Seller_Sales.SecondSeller_ID.
One of the relationships is active and the other one is inactive. Both of them have a n:1 and single relationship.
I thought about using USERELATIONSHIP but it's not working bc I'm not working with integer or any kind of numbers.
I would be glad if anyone could help me!
Best regards
