You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Custom sort OTBI Column

in Reporting and Analytics for ERP 8 comments

I have a column in my otbi analysis.

They return me the values Exceeds Performance Expectations, Inadequate, Meets Performance Expectations ,Nearly there, No PMS Rating.

The order I want to display them in my report is Inadequate, Nearly there, Meets Performance Expectations, Exceeds Performance Expectations, No PMS Rating.


How to custom sort them?

Even if I use case statement like this , it does not work.

CASE WHEN "Custom Columns"."Custom Segment46 Meaning" = 'Inadequate' THEN 'Inadequate'

WHEN "Custom Columns"."Custom Segment46 Meaning" = 'Nearly there' THEN 'Nearly there'

WHEN "Custom Columns"."Custom Segment46 Meaning" = 'Meets Performance Expectations' THEN 'Meets Performance Expectations'

WHEN "Custom Columns"."Custom Segment46 Meaning" = 'Exceeds Performance Expectations' THEN 'Exceeds Performance Expectations'

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!