COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: AJ123 on 07 Aug 2017 02:20:49 PM

Title: Sorting a column in crosstab
Post by: AJ123 on 07 Aug 2017 02:20:49 PM
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