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

[TABLE="width: 500"]
<tbody>[TR]
[TD]Item Code
[/TD]
[TD]Color[/TD]
[TD]Quantity[/TD]
[TD]Date Sold - Purchased[/TD]
[TD]Invoice Number[/TD]
[TD]Status[/TD]
[TD]issue Status[/TD]
[/TR]
[TR]
[TD]ipad2
[/TD]
[TD]White
[/TD]
[TD]-213
[/TD]
[TD]2014-01-25
[/TD]
[TD]I2514
[/TD]
[TD]
[/TD]
[TD]SOLD
[/TD]
[/TR]
[TR]
[TD]ipad2
[/TD]
[TD]White
[/TD]
[TD]210
[/TD]
[TD]2014-02-25
[/TD]
[TD][/TD]
[TD]Purchased
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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