4 Replies Latest reply on May 8, 2017 11:53 AM by Marcelo Scharan

    Exclude Duplicated Values

    Marcelo Scharan

      I have a data set (.csv) where I have basically something similar like this:

       

      IDDescription
      Cost
      001Service ABCD$ 10.00
      002Service BCDE$ 5.00
      001Service ABCD$ 10.00
      003Service CDEF$ 6.00
      002Service BCDE$ 5.00
      004Service DEFG$ 8.00
      003Service CDEF$ 6.00
      004Service DEFG$ 8.00

       

      I need to exclude all IDs duplicated because Tableau is counting all the costs regardless if they have a duplicated ID. It need's to be a formula or something like that because we are talking over 500.000 IDs.

       

      Tks!