3 Replies Latest reply on Sep 27, 2018 11:29 PM by Tushar More

    same number add once

    sunny shang

      Hi guys,

       

      When  I did the tableau, I faced a problem. I would like to create a filed, that is --the same bankcard number to add once and get the total loan, the total loan should be 15000, and bankcard number 2 is duplicate, so the loan amount of bankcard 2 should be add only once. I know I may use countd and sum, but I don't know how can I deal with it exactly using formula in tableau?