Sort based on criteria? — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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
John Bruso1
John Bruso1 Rank 6 - Analytics Lead
in Oracle Analytics Cloud and Server

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