Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 48 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 286 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 110 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Sort based on criteria?
John Bruso1
Rank 6 - Analytics & AI Lead
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
0
Answers
-
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.
0