6 Replies Latest reply on Jun 12, 2018 4:43 AM by sudheer.kumar.5

    distinct count based on 3 fields help

    Imran Azam

      Hi Guys

       

      i am trying to do count based on if the combination of 3 fields are distinct

       

      i have the data below  when i do a count distinct i ma getting 7 when i answer should be 5

       

      NAME
      A_ID

      BID   

      A11
      A11
      A12
      B22
      B22
      B33
      B

       

      how can i do this ?

       

      thank