Embedded Analytics UK

 1)when i am using Relationship (many to many) for merging ,it is giving inventory only for corresponding sale . but it is not showing the inventory which is not sold.

Target :- here after merging i want to show inventory for all whether it is sold or not .

if item is in my inventory and it is not sold then in net sale qty list it should show zero in front of inventory list(Net Qty).

same if some items are fully sold but not in my inventory then in my Net Qty(inventory) list it should show zero in front of sold items.

2) when i am using full outer join for merging , it is giving so much null and duplicate values and also totally wrong results ( large values than actual due to duplicates) for inventory and sales . how to avoid these duplicates ?

in both method i cross validate from actual excel sheet.

sales data :- 18 columns (fields)

inventory data :- 12 columns

in which 8 fields are common

here is my .twbx file and csv file for sale and inventory