I have a table which summarises the number of sales of tshirts of each colour combination (its actually much bigger than this)
I'd like to show a list of the top 10 most popular colour combos so somehow i have to find the highest 10 values from these cells and display a list of them, in order, showing both colours and the number of sales they've had. I'm not sure how to go about this. Is there a function for this?
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
best sellers:
black on white - 7
blue on gold - 5
black on sand - 3
etc
I'd like to show a list of the top 10 most popular colour combos so somehow i have to find the highest 10 values from these cells and display a list of them, in order, showing both colours and the number of sales they've had. I'm not sure how to go about this. Is there a function for this?
white | black | red | green | blue | yellow | pink | grey | |
white | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 0 |
Ice Grey | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Sport Grey | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Vegas Gold | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Natural | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Sand | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 |
Daisy | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Safety Green | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Yellow Haze | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Gold | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 |
Old Gold | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
best sellers:
black on white - 7
blue on gold - 5
black on sand - 3
etc