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!

       

       

      Mattia