Hi There ,
I am working on sales data , there are categories and sub categories of the products ( Like nail paints will come in cosmetics , and hair Oil comes in sub cosmetic) every week sales pattern is getting changed – I want to dig out top ten products per category / per week .
Is there any formula / macro we can apply.
Pls look in the same and guide.
I am working on sales data , there are categories and sub categories of the products ( Like nail paints will come in cosmetics , and hair Oil comes in sub cosmetic) every week sales pattern is getting changed – I want to dig out top ten products per category / per week .
Is there any formula / macro we can apply.
Pls look in the same and guide.