7 Replies Latest reply on Aug 4, 2017 2:01 AM by Mihai Constantinescu

    Distinct Count for Duplicates

    chakradhar kakani

      Hello Tableau users,

       

      I'm looking for a small help in removing Duplicates. I know Distinct count returns a Unique Values.. I have attached a sample Workbook where i'm looking for only those ID's that are present only in one Type.. otherwise remove those ID's ..

       

      For example ID 12 is present in both the type AA and BB so i dont want to count that.. same with that 34 was present on BB and CC so dont count that.. i want only those ID's that were present only on one TYPEonly at a time.

       

      Appreciate your help.

       

       

      IDTYPE
      12AA
      11AA
      23AA
      87BB
      12BB
      34BB
      34CC
      98CC