Column with the same name in two tables - incorrect calculations
Hi,
i’m trying to add target from table master:
supplier, target
1, 10% 2, 15%
in table sales i also have column supplier containing supplier 1 and 2 and others that are not in table master.
when i add supplier dim into any table, chart etc i can see only suppliers from my master table even though there’s more suppliers in sales table. Is there a way to do any calculations for all suppliers from sales table?
