Hi all,
I'm trying to highlight any monthly spikes in sales of the following data within a pivot table. Each line represents a product and I want to see which have large increases so we can prepare for that month in advanced. I've tried some conditional formatting per row but it would take forever to apply this to each product and wouldn't give a clear indicator in another table .
I've also tried standard deviation formulas per product which appears in another table, where if the standard deviation is really high you can check that SKU and identify the month where the spikes occur. The lower SD's will be ignored. However, when reviewing the data spikes where still occurring where SD was low.
How would I manipulate each SKU to give a value in a separate table/cell that indicates to check the SKU as there is a harsh spike?
Much appreciated.
I'm trying to highlight any monthly spikes in sales of the following data within a pivot table. Each line represents a product and I want to see which have large increases so we can prepare for that month in advanced. I've tried some conditional formatting per row but it would take forever to apply this to each product and wouldn't give a clear indicator in another table .
I've also tried standard deviation formulas per product which appears in another table, where if the standard deviation is really high you can check that SKU and identify the month where the spikes occur. The lower SD's will be ignored. However, when reviewing the data spikes where still occurring where SD was low.
How would I manipulate each SKU to give a value in a separate table/cell that indicates to check the SKU as there is a harsh spike?
Much appreciated.