[TABLE="width: 500"]
<tbody>[TR]
[TD]sku[/TD]
[TD]coun[/TD]
[TD]category[/TD]
[TD]color[/TD]
[TD]gpm[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]15[/TD]
[TD]basket[/TD]
[TD]red[/TD]
[TD]90[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]15[/TD]
[TD]basket[/TD]
[TD]blu[/TD]
[TD]91[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]20[/TD]
[TD]pottery[/TD]
[TD]purple[/TD]
[TD]95[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]18[/TD]
[TD]pottery[/TD]
[TD]blue[/TD]
[TD]91[/TD]
[/TR]
</tbody>[/TABLE]
Hello,
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!
<tbody>[TR]
[TD]sku[/TD]
[TD]coun[/TD]
[TD]category[/TD]
[TD]color[/TD]
[TD]gpm[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]15[/TD]
[TD]basket[/TD]
[TD]red[/TD]
[TD]90[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]15[/TD]
[TD]basket[/TD]
[TD]blu[/TD]
[TD]91[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]20[/TD]
[TD]pottery[/TD]
[TD]purple[/TD]
[TD]95[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]18[/TD]
[TD]pottery[/TD]
[TD]blue[/TD]
[TD]91[/TD]
[/TR]
</tbody>[/TABLE]
Hello,
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!