3 Replies Latest reply: Dec 16, 2012 7:39 PM by Donna Aranzanso RSS

    Set Analysis or Scripting?

      Hi All,

       

      What approach is best for this problem?

       

      I have a table

       

      IDID2Date
      S-1111/17/2012
      S-2112/12/2012
      R-121/17/2012
      R-1b35/4/2012
      R-1c46/12/12

       

      I need to get all the ID that have a count of 1 in ID2.

      if(count(ID2)=1, ID)

      So I need to get all the ID with only 1 count for ID2 and the specific date.

      How can I achieve this?

       

      Answer base on the table:

      IDs..

      R-1 - 1/17/2012

      R-1b - 5/4/2012

      R-1c - 6/12/12

       

      I need to show this in Pivot Table.

       

       

      Thanks,

      Donna