9 Replies Latest reply on Jun 13, 2013 8:56 AM by Joshua Milligan

    sum a field for Distinct record id's

    W H

      I'm a Tableau newbie, so my apologies if this question has been covered elsewhere.  Under the gun to get a report done.....I have this file of transaction records.   The main identifier is called EmployeeNum.  There will be multiple records for any given EmployeeNum.  I need to add up all the values for FIELD3, for each distinct occurrence of EmployeeNum.  FIELD3 will be the same value across all of the records for a given EmployeeNum.   I know how to SUM FIELD3, and I know how to get Distinct EmployeeNum's... but I can't seem to figure out how to get the SUM of FIELD3 for Distinct EmployeeNum's. 

       

      Thanks!