I have two tables:
1. Lists all Customer+SKU combinations and has sales by month -- no duplicates
2. Lists all Customer+SKU combinations and has other customer attributes (location, type, etc.) -- may have duplicate Customer+SKU values
So I created a relationship between these two tables based on Customer+SKU.
I create a pivot with the data model and drag in Customer Type from table # 2. I then bring in YTD sales from table #1. But I get a notification saying Relationships are needed and all of my Values are the totals (in other words, it's not showing the proper value per customer type).
What am I doing wrong here? I thought this sort of thing is specifically what relationships are for?
1. Lists all Customer+SKU combinations and has sales by month -- no duplicates
2. Lists all Customer+SKU combinations and has other customer attributes (location, type, etc.) -- may have duplicate Customer+SKU values
So I created a relationship between these two tables based on Customer+SKU.
I create a pivot with the data model and drag in Customer Type from table # 2. I then bring in YTD sales from table #1. But I get a notification saying Relationships are needed and all of my Values are the totals (in other words, it's not showing the proper value per customer type).
What am I doing wrong here? I thought this sort of thing is specifically what relationships are for?
