Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Oracle CRM On Demand Archived Forums
CRM On Demand Integration Development
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Nov 29, 2012 3:14 AM by
Filter on Mutli-Select Picklist based on another column
Nov 29, 2012 3:14 AM
I have 2 columns in a report, the first one is Account Post Code (OOTB) and other is the custom multi-select picklist Service Area which contains multiple post codes.
The report looks like.
Post Code Service Area
1 - 1,2,3,4
1 - 2,3,4
So ideally I want to show only the first row, since Service Area contains value 1 which is the value of the Post Code. I don't want the 2nd row since we don't have the value 1 on the Service Area.
Can we do this in Answers on Demand? Any Case statement or any other approach. Kindly advice.
Edited by: 965307 on Nov 29, 2012 1:13 AM
Edited by: 965307 on Nov 29, 2012 1:14 AM
This content has been marked as final.
Show 0 replies