Jan 19 2018 02:57 PM
Hi,
I have item skus (a-1,a-2,b-1,b-2) with sold qty columns.
I'd like to sort by qty first then list same type of skus.
sku | qty
-----------------
a-1 | 5
b-1 | 4
a-2 | 3
b-2 | 2
Sort by qty then list related sku between next sku best selling sku.
sku | qty
-----------------
a-1 | 5 <------- #1 sales
a-2 | 3 <------- related sku with #1 sales
b-1 | 4 <------- #2 sales
b-2 | 2 <------- related sku with #2 sales
I tried multiple sort option but no luck.
Please advise.
Thank you,
David
Jan 19 2018 08:35 PM
Try to sort the QTY column from smallest to largest, then sort the SKU column from A to Z.