Sorting horizontal columns in a cross table issue

I have 6 columns on the vertical axis and 10 on the horizontal axis in a cross table.  I am not able to sort on the horizontal columns.  I can click on a column header and I get the "arrow" indicating a sort order but nothing happens.  I find that if I remove all but one column from the vertical axis then I can sort on the horizontal columns.  The thing is I need the additional columns.  Is there any work around for this?  Anyone have a different experience?

(1) Answer