JackChang
03-20-2020, 02:03 PM
All-
I was looking for some suggestions on how I might be able to identify declining sales by sku. I'm trying to see which sku's we should discontinue selling and not reorder. (i.e. they're not selling)
On the file attached, I have monthly data by sku, but rather than going through each row, is there some function/feature in Excel to make it easier? I used a sparkline, so I can put an 'x' next to the ones that are declining, but it's still a manual task especially when I have thousands to review. And then it changes when I add in new monthly data and the process starts all over again.
Anyone have any ideas on how to get to the data I need, without the noise?
Thank you,
I was looking for some suggestions on how I might be able to identify declining sales by sku. I'm trying to see which sku's we should discontinue selling and not reorder. (i.e. they're not selling)
On the file attached, I have monthly data by sku, but rather than going through each row, is there some function/feature in Excel to make it easier? I used a sparkline, so I can put an 'x' next to the ones that are declining, but it's still a manual task especially when I have thousands to review. And then it changes when I add in new monthly data and the process starts all over again.
Anyone have any ideas on how to get to the data I need, without the noise?
Thank you,