Hi There,
I am trying to get a weighted ranking that uses dollars as the highest weighting. We are looking at a list or items and evaluating their weeks spent below their intend MSRP and wanted to rank them by importance using a count of the weeks below MSRP and their YTD Sales to rank them.
I am not sure if what I am asking for is possible. In the attached example, the list is small. In the data set i am working with, there are hundreds of entries.
<tbody>
</tbody>
I am trying to get a weighted ranking that uses dollars as the highest weighting. We are looking at a list or items and evaluating their weeks spent below their intend MSRP and wanted to rank them by importance using a count of the weeks below MSRP and their YTD Sales to rank them.
I am not sure if what I am asking for is possible. In the attached example, the list is small. In the data set i am working with, there are hundreds of entries.
Weeks | |||||||||||||
MSRP | YTD Volume | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | Count below MSRP | Desired Rank | |
Item1 | 1.99 | $ 100,000 | $ 1.39 | $ 1.39 | $ 1.39 | $ 1.39 | $ 1.39 | $ 1.39 | $ 1.39 | $ 1.39 | $ 1.39 | 9 | 3 |
Item2 | 2.99 | $ 150,000 | $ 2.99 | $ 2.99 | $ 2.99 | $ 2.99 | $ 2.99 | $ 2.99 | $ 2.84 | $ 2.84 | $ 2.84 | 3 | 5 |
Item3 | 3.99 | $ 190,000 | $ 3.99 | $ 3.99 | $ 3.99 | $ 3.99 | $ 3.99 | $ 3.99 | $ 3.99 | $ 3.99 | $ 3.99 | 0 | 7 |
Item4 | 4.99 | $ 50,000 | $ 3.99 | $ 3.99 | $ 3.99 | $ 3.99 | $ 3.99 | $ 3.99 | $ 3.99 | $ 3.99 | $ 3.99 | 9 | 4 |
Item5 | 5.99 | $ 250,000 | $ 3.59 | $ 3.59 | $ 3.59 | $ 3.59 | $ 3.59 | $ 3.59 | $ 3.59 | $ 3.59 | $ 3.59 | 9 | 2 |
Item6 | 6.99 | $ 1,000,000 | $ 3.50 | $ 3.50 | $ 3.50 | $ 3.50 | $ 3.50 | $ 3.50 | $ 3.50 | $ 3.50 | $ 3.50 | 9 | 1 |
Item7 | 7.99 | $ 75,000 | $ 7.99 | $ 7.99 | $ 7.99 | $ 7.99 | $ 7.99 | $ 7.99 | $ 7.99 | $ 7.99 | $ 7.99 | 0 | 8 |
Item8 | 8.99 | $ 5,000 | $ 4.50 | $ 4.50 | $ 4.50 | $ 4.50 | $ 4.50 | $ 4.50 | $ 4.50 | $ 4.50 | $ 4.50 | 9 | 6 |
<tbody>
</tbody>