Set Analysis modify set by field value of another tabel
Hope somebody can help me on this.
I have 2 tables, one table contains item/DKU specific informations, the other Inventory quantities by item/sku and location/warehouse
my target is to make a straight table with SKU and SKUdescription as dimension and as expression total inventory, plus the inventory from the DefaultWarehouse. The default warehouse is defined in the SKU Data Table and the Inventory quantities by item are in the Stock information Table. (see attached qvw)