Hello,
I've on my best to read through al the other rank posts but I'm till not seeing what I need.
Basically I have a complex list of criteria that I need to rank within itself.
For example:
(CHANNEL) (SPORT) (GENDER) (RETAILER) (STYLE NAME) (UNITS BOUGHT)
SG RUN MEN RT A ABC123 1000
SG BSK WMN RT B ABC124 1000
How do I rank the style name by the units bought within the channel, sport, gender, retailer?
In the end, I want to identify a style name that has not been bought by a selected retailer (of my choice) but is in the top ten in the channel, sport, gender amongst retailers.
I've on my best to read through al the other rank posts but I'm till not seeing what I need.
Basically I have a complex list of criteria that I need to rank within itself.
For example:
(CHANNEL) (SPORT) (GENDER) (RETAILER) (STYLE NAME) (UNITS BOUGHT)
SG RUN MEN RT A ABC123 1000
SG BSK WMN RT B ABC124 1000
How do I rank the style name by the units bought within the channel, sport, gender, retailer?
In the end, I want to identify a style name that has not been bought by a selected retailer (of my choice) but is in the top ten in the channel, sport, gender amongst retailers.