Forum Discussion
Multiple relationships between multiple tables
Hi, I have an issue with relationships set in my dataset. I have 4 related tables Calendar, Sales Data, Brands, Forecast, with the below relationships: 1. Calendar => Forecast (Date=Date)...
Anonymous , if both tables have the sales channel, create a common table and use that to filter
refer
HI amitchandak ,
Thanks for your response. the problem is taht the sales channel is a calculated column that is a result of another 2 tables. I have a common customer table where I've created a calculated column and identified the channel by customer. Now I have a "common" table that can relate as below with:
1. Customer Table => Sales Table (Cutomer ID=Customer ID)
2. Customer Table => Forecast Table (Sales Channel=Sales Channel)
however I receive an error that the relationship cannot be set due to ambiguity that it creates..