3 Replies Latest reply on Jul 11, 2016 2:17 AM by Mark Fraser

    How to sum the unique values in tableau

    Sumit Singla

      Hi Everyone,

       

      I have below data and I want to calculate the sum of unique values of each customer in tableau.

       

      name      sal    

      xyz         100

      xyz          200

      xyz         100

      abc        10

      abc        10

      abc        20

       

      the sum should be 330 which is the sum of unique values for xyz customer and abc customer.

       

      Can anyone suggest me if we have any function in tableau to calculate the same.

       

      Thanks and Regards,

      Sumit Singla