If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

how to sort category items in bar chart(not alphabatically)

Started by nancysinghal, 29 Jun 2016 07:14:39 AM

Previous topic - Next topic

nancysinghal

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