4 Replies Latest reply on Nov 1, 2012 8:00 AM by Alex Kerin

    Sum a distinct numeric field.

    Kevin Baes

      Hi, I am new to Tableau software.  I was wondering if there is a way to sum a distinct numeric field such as a paid amount.  The data I am using is on a line level and the paid field repeats per claim.  In order to get an accurate summation of the paid field, I need to sum a distinct amount.  Thanks!

       

      Attached is dummy data I made that replicates the issue.  As of right now, it seems Tableau sums the Amt_Paid field on a line level.  What I need is a distinct summation based on claim level.  So, the total amt_paid field needs to be $1,600. Thanks!