I am trying to find the Turn Rate of products by vendor. The calculation is product sales divided by the product inventory value (simple calculation Inventory qty * product cost). The inventory qty and the product cost are on a "product table" and the Sales Amount is on the "Sales by Item table". I inner joined the two tables by product sku. The issue is that there may be more than one sale by sku number and each time the sku number comes up in a sale the inventory for that item is counted twice, when I sum the inventory the amount of the inventory is wrong.
I am not sure how to get the answer I am looking for.
Thanks for your help.
I don't think there's a way to get what you want without limiting the data in some way. But you can do a 'Group By' in your dataflow after the join and group it by SKU to get its inventory, sales, quantity sold, etc. in a certain time period. You could then have a drill down into your original dataset to get order and SKU details.