9 Replies Latest reply: Aug 12, 2015 12:16 AM by Sunny Talwar RSS

    Lookup on same column

    Disha Ahuja

      Hi,

       

      I have a following sample data:

       

      STATUSNamePROP_NO
      50JIC100
      90JIC120
      50JIC150
      90JIC154
      50JIC162
      90JIC183
      50JIC194
      50JIC101
      OCIC100
      CCIC100
      OCIC120
      CCIC120
      CCIC138
      CCIC143
      OCIC162

       

      I want to perform a calculation where i need a count of those PROP_NO which have STATUS=50 in JIC and are present in CIC.

       

      For example: in this sample data, the count should be 2 (PROP_NO 100 and 162 has STATUS=50 in JIC and are present in CIC)

       

      Kindly help me with the logic to be applied in set analysis.

       

      Thanks in advance.