0 Replies Latest reply: Nov 29, 2012 3:14 AM by 968310 RSS

    Filter on Mutli-Select Picklist based on another column


      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