Sort based on criteria? — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Sort based on criteria?

Received Response
21
Views
1
Comments

Summary

Sort based on criteria?

Content

Hi All,

 

I'd like to sort my results based on County in ASC order. However, there is 1 result with a county value of 'Various' that I would like to be dead last, after the County's that start with W,X,Y,Z. Is this possible in either BIP or the peopelsoft query itself?

 

Order Example:

 

Albany

Carbon

Devon

Washaki

Weston

Zebra

Various

 

Thanks!

 

John

Answers

  • John Bruso1
    John Bruso1 Rank 6 - Analytics Lead

    I figured it out... the trick was to add a dummy field to the PS query with a Case expression changing the value of the Various County to 'ZVA' and then sorting on that field.

    Dummy_Field.PNG