Oracle Analytics and AI

John Bruso1

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

John Bruso1

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.