Cross Table Not sorting

[Tauseef Sheik]

I have a cross table which doesn't sort if I add another column in the cross table. See image for more better understanding. In image 1 i added a new column called cabin. After which if i try to sort the table the sorting doesn't work. If I select the option of ignore hierarchy then it sorts but then it ignores the column which I require. After I add the new column it shows me the resultsorted on the first column of cross table alphabetically.