Forum Discussion
Product with more than one value for the same Classification
Hi,
Share some data and show the expected result.
My database has products which are produced in more than one Origin (ex.: Europa, LA, Canada, etc...). At the same time, my facts data tables (Sales, Purchase, Budget) also have the same column Origin on it. My product table can have only one row by sku and my origin table have one local for each Origin.
When I connect the table Product with the table Origin (linked by Origin) and the table Product with the tables Facts (linked by sku), I can not connect the table Origin with the tables Facts, because it generates a circular condition. And if I can't connect both tables Origin and Products with the Facts table, I face filter problems issues. It doesn't filter correctly the Origin volumes or I can't filter the infos for one single sku.
I have included a photo in this topic.