Cross Tab don't do the sorting the way i want

[scwk]

hello all

i'm having a pb which i'm looking and finding a way to resolve but in vain
Cross Tab don't do the sorting the way i want
on the row side, i've first client type then client code then client name and then Equity Return
on the column side i've the stocknames and on the summarized i've the weight

so on each row we can do a sorting, it takes it automatically
what i want is a sort by client types, and Equity Return(so its the first row and the 4th row)
But it always sort by client type and client code...
i use the sort button also, but the result is the same.

What should be done?
in the cross tab there is not the option of choosing the original order....
Please help
Many thks

SC