1 Reply Latest reply on Feb 29, 2016 5:57 AM by pooja.gandhi

    Calculation Order - Price Volume Mix

    Budi Lubis

      I am creating a simple YOY price, volume, and mix change but can't figure out to why Tableau is not giving the right answer.  The following is a simple data set:

      Code
      DatePriceUnitSales
      A1/1/2015$34$12
      A1/1/2016$46$24

       

      The formulas are as follow and a calculated field has been created for each variable:

       

      • Price Change = (2016 Price - 2015 Price) * 2015 Unit = ($4-$3)*4 = $4
      • Unit Change = (2016 Unit - 2015 Unit) * 2015 Price = (6-4)*$3 = $6
      • Mix Change = (2016 Price - 2015 Price) * (2016 Unit - 2015 Unit) = ($4-$3)*(6-4) = $2

       

      For Price Change and Unit Change somehow Tableau always return 0 for 2016 unit and 2016 price which and shows -$12 as the result.  For Mix Chage, I have no idea to why Tableau is returning $36.

       

      Is it a calculation order?  Any clue?

       

      Thank you much for the help!

       

      PVM - Calculation.png