trouble with sorting by 'x' then 'z'

[joeloveszoe]

hi
my data loos like this

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Helvetica}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: center; font: 11.0px Helvetica}p.p3 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: right; font: 11.0px Helvetica}table.t1 {border-collapse: collapse}td.td1 {border-style: solid; border-width: 1.0px 1.0px 1.0px 1.0px; border-color: #cbcbcb #cbcbcb #cbcbcb #cbcbcb ; padding: 0.0px 5.0px 0.0px 5.0px}</style>[TABLE="class: t1"]
<tbody>[TR]
[TD="class: td1"]sku
[/TD]
[TD="class: td1"]status
[/TD]
[TD="class: td1"]productname
[/TD]
[TD="class: td1"]siteprice
[/TD]
[TD="class: td1"]listprice
[/TD]
[TD="class: td1"]sitecost
[/TD]
[TD="class: td1"]minimumqty
[/TD]
[/TR]
[TR]
[TD="class: td1"]ACC72010-BULK
[/TD]
[TD="class: td1"]TRUE
[/TD]
[TD="class: td1"]Acco Binder Clip
[/TD]
[TD="class: td1"]0.47
[/TD]
[TD="class: td1"]1.88
[/TD]
[TD="class: td1"]0.36
[/TD]
[TD="class: td1"]360
[/TD]
[/TR]
[TR]
[TD="class: td1"]ACC72020-BULK
[/TD]
[TD="class: td1"]TRUE
[/TD]
[TD="class: td1"]Acco Binder Clip
[/TD]
[TD="class: td1"]0.47
[/TD]
[TD="class: td1"]1.88
[/TD]
[TD="class: td1"]0.36
[/TD]
[TD="class: td1"]288
[/TD]
[/TR]
[TR]
[TD="class: td1"]MEA63352-BULK
[/TD]
[TD="class: td1"]TRUE
[/TD]
[TD="class: td1"]Mead Plain Index Card
[/TD]
[TD="class: td1"]0.46
[/TD]
[TD="class: td1"]1.39
[/TD]
[TD="class: td1"]0.37
[/TD]
[TD="class: td1"]2736
[/TD]
[/TR]
[TR]
[TD="class: td1"]MEA45354-BULK
[/TD]
[TD="class: td1"]TRUE
[/TD]
[TD="class: td1"]Mead Coil Memo Notebook
[/TD]
[TD="class: td1"]0.55
[/TD]
[TD="class: td1"]1.49
[/TD]
[TD="class: td1"]0.44
[/TD]
[TD="class: td1"]2304
[/TD]
[/TR]
[TR]
[TD="class: td1"]MEA45464-BULK
[/TD]
[TD="class: td1"]TRUE
[/TD]
[TD="class: td1"]Mead Coil Memo Notebook
[/TD]
[TD="class: td1"]0.55
[/TD]
[TD="class: td1"]1.49
[/TD]
[TD="class: td1"]0.44
[/TD]
[TD="class: td1"]2304
[/TD]
[/TR]
[TR]
[TD="class: td1"]MEA45534-BULK
[/TD]
[TD="class: td1"]TRUE
[/TD]
[TD="class: td1"]Mead Wire Binding Coil Memo Notebooks
[/TD]
[TD="class: td1"]0.55
[/TD]
[TD="class: td1"]1.49
[/TD]
[TD="class: td1"]0.44
[/TD]
[TD="class: td1"]2304
[/TD]
[/TR]
[TR]
[TD="class: td1"]MEA45644-BULK
[/TD]
[TD="class: td1"]TRUE
[/TD]
[TD="class: td1"]Mead Open Side Memo Notebook
[/TD]
[TD="class: td1"]0.55
[/TD]
[TD="class: td1"]1.49
[/TD]
[TD="class: td1"]0.44
[/TD]
[TD="class: td1"]2304
[/TD]
[/TR]
[TR]
[TD="class: td1"]WLJ54309-BULK
[/TD]
[TD="class: td1"]TRUE
[/TD]
[TD="class: td1"]Wilson Jones Insertable Tab Indexes
[/TD]
[TD="class: td1"]0.63
[/TD]
[TD="class: td1"]1.53
[/TD]
[TD="class: td1"]0.48
[/TD]
[TD="class: td1"]216
[/TD]
[/TR]
[TR]
[TD="class: td1"]WLJ54310-BULK
[/TD]
[TD="class: td1"]TRUE
[/TD]
[TD="class: td1"]Wilson Jones Insertable Tab Indexes
[/TD]
[TD="class: td1"]0.63
[/TD]
[TD="class: td1"]1.53
[/TD]
[TD="class: td1"]0.48
[/TD]
[TD="class: td1"]216
[/TD]
[/TR]
[TR]
[TD="class: td1"]MEA33100-BULK
[/TD]
[TD="class: td1"]TRUE
[/TD]
[TD="class: td1"]Mead 3-hole Punched Portfolio
[/TD]
[TD="class: td1"]0.64
[/TD]
[TD="class: td1"]1.39
[/TD]
[TD="class: td1"]0.51
[/TD]
[TD="class: td1"]1968
[/TD]
[/TR]
</tbody>[/TABLE]

i am trying to sort by sku then sitecost - but it will not let me
any suggestions why it will only set by my 1st level?

thanks very much!
=) joe

 

[Joe4]

You should be able to do that pretty easily.
It looks like you have the sort order reversed, where you have it sorting by sitecost first, then SKU.
Make sure the SKU field is the first sort priority.

 

[NewTricks]

In the data presented, every entry in sku is unique, therefore a secondary sort is moot. If this is only a sample of the data, look down the sku field to find duplicates; only there will a secondary sort change the order.