Calculate Slow Moving Products

[djmurray]

Hi Guys,

So I have List of products sold (to customers) and purchases (into the warehouse)

I am now looking to summarise the data to see which products are slow moving.

The fields I have are

Item Code	Color	Quantity	Date Sold - Purchased	Invoice Number	Status	issue Status
ipad2	White	-213	2014-01-25	I2514		SOLD
ipad2	White	210	2014-02-25		Purchased

<tbody>
</tbody>

Blue being a sales, and read being a top up order. I have though about doing this in pivot table, but I cant seem to work out how to calculate it correctly. Any help would be really appreciated.

Thanks!

 

[oldbrewer]

what you buy in is irrelevant - you need to know for each product how many sold last 3 months, last 6 months and last year.

easy to do with sumproduct