Need advise with Sorting

Copper Contributor

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

1 Reply

Try to sort the QTY column from smallest to largest, then sort the SKU column from A to Z.