sku | coun | category | color | gpm |
1 | 15 | basket | red | 90 |
2 | 15 | basket | blu | 91 |
3 | 20 | pottery | purple | 95 |
4 | 18 | pottery | blue | 91 |
<tbody>
</tbody>
I need to select the top gpm sku, 2nd top sku, 3rd etc. per category. My result table is set up like this spread sheet is set up like this
1 2 3 4 5 (column headings)
Basket
Pottery
Tupperware
Etc.
(Row headings)
Thanks!