6 Replies Latest reply on Mar 16, 2018 9:30 AM by Saran De

    How to find Counts

    mahesh p

      Hi am having data like below

       

      IDVersion
      ANA
      BNA
      CNA
      D1
      A1
      A2
      E3

       

       

      now my requirement is to get like

       

       

      VersionCount
      NA2
      12
      22
      31

       

       

      if any Id having a version that should not include in "NA" for example "A" first we have that id for "NA" so we have to exclude that id for "NA" and same id we have for version 1 and version 2 we have to include the count for both 1 and 2 versions.

       

      Thanks in advance.