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?
thank you in advance