COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Active Reports => Topic started by: nancysinghal on 29 Jun 2016 07:14:39 AM

Title: how to sort category items in bar chart(not alphabatically)
Post by: nancysinghal on 29 Jun 2016 07:14:39 AM
Hi ,

I have a requirement wherein , i need to sort Category items(x-axis) in a particular order.
For instance, the values that comes up in x-axis should come like, 'Application Registration Pending' in the first bar , 'Interview No Show' in the second bar, 'Application Disposition' in the third bar and so on.

I tried creating a data item with case stmt and applied sorting on categories using this data item, but it throws error:
The 'ces_when' function is not supported in the context in which it is used.

Case stmt:
case when
[Dimensional Layer].[Dim App Status].[Status Type Flag].[App Status]=[Interview No Show]
then
1
when
[Dimensional Layer].[Dim App Status].[Status Type Flag].[App Status]=[Application Disposition SRED]
then
2
end

Please suggest any work around.

Regards,
Nancy