I am working on inventory and sales analysis. For particular sku code there are different order created date and different order purchase date. How to add a column quantity which displays this much quantity of stock has been created on this date and a seperate quantity column which displays this much quantity has been sold on particular date for particular sku code. Then how to calculate the frequency of date, i.e. this squ code has been sold in these many days.
