Sorting a column in crosstab

[AJ123]

Hi,

I have a crosstab report where I have to sort on the 3rd column in the crosstab

there is a column which id hidden between 2nd and 3rd column which is then displayed in the 4th column I want to sort on the 3rd column but the 4th column which was hidden is getting sorted (grouped by) I want a way where I can sort on the 3rd column. I have tried all advanced sorting and dimensional sorting technique but nothing works 

FYI.. the source is dynamic cube.

Thanks in advance