2 Replies Latest reply on Aug 21, 2014 4:25 PM by Mattia Pradella

    Sum distinct from multiple dta sources

    Mattia Pradella

      Hi Great People,


      I have a problem I tried to simplify in the attached file.


      I have “daily empty” by customer on one file and “nominal customer weight” on the other file and I use CUSTOMER_CODE as relationship field.


      I would like Tableau to calculate the daily “empty * nominal” as a sum of :


      customer nominal weight* customer empty.


      At this stage tableau does the multiplication of the sum of the empty * sum of all the weights.


      As 1st of august the number I’m expecting as “empty * nominal” is 739 and not 68607 as I’m getting now.



      Any help or comment is welcome!