2 Replies Latest reply on Jul 16, 2012 1:05 AM by Serge GABRIEL

    Problem with "Sum of Max" and "Sum of Min"

    Serge GABRIEL

      Hello,

       

      I have a problem with one visualization on Tableau (Calculation)

      Please find more details and an example on the attached file.

       

      Sheet "Prices MIN/MAX"

       

      I calculate for several components, supplied by different suppliers, the Sum of all cheapest suppliers and the sum of all most expensive suppliers. The problem is when two suppliers have the same price for a component, the sum count 2 times the price in my calculation. How to avoid it???

       

      Thanks for your help!

      Kind regards,

      Serge