COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: barrysaab on 16 Jun 2013 08:44:10 AM

Title: Month sorting on Crosstab
Post by: barrysaab on 16 Jun 2013 08:44:10 AM
Hi gurus, I have Product Id on rows and month as columns in Crosstab,but the month is not appearing in proper order for example Jan,Feb----Dec.I remember doing the same for list report a while ago by taking a new data item and writing a case statement of If month='Janauary then (1) .Do I need to do same thing for crosstab too.Appreciate your help.Thanks
Title: Re: Month sorting on Crosstab
Post by: blom0344 on 17 Jun 2013 01:31:07 AM
Yes, do the same for the crosstab. You can associate this data-item with the crosstab , by adding it to the properties of the crosstab header if you do not want it in the layout..