Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 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
To use Custom Sort option in DV Filter
ALOK SH-Oracle
Rank 6 - Analytics & AI Lead
Actually we have requirement to show DV filter value in custom order not in alphabet order.
eg if i have one column called Department Name where department name value is : HR ,IT ,Admin, Sales ,Finance
In DV Filter i have to show this value in order in HR ,IT ,Admin, Sales ,Finance.
How to can show this value in DV Filter.
I can understand we have Parameter option but not work for all.
Any suggestion would be appreciated.
Tagged:
3
Comments
-
I have tried .We can achieve this scenario by use of parameter where we can use logical sql query with order by condition. In order by condition we can use case statement.
1 -
Thank you for sharing!
0
