I am trying to learn powerpivot and am having some issues establishing relationships between tables. I have three tables:
1. Sales data, which contains monthly sales in dollars and quantity and gm by brand
2. Deductions which contains coop and other deductions by brand
3. Returns which contains product returns by brand
I tried to link them by brands, but I get a message that says that duplicate values exist. I attached a small sample.
Any help would be appreciated. Thank you.