1 2 Previous Next 17 Replies Latest reply on May 3, 2017 9:36 AM by Alex Martino

    Calculation Order - Price Volume Mix Calculation

    Budi Lubis

      I am trying to calculate a YOY price volume mix but can't seem to figure out to why Tableau can't seem to give the right answer; the following is the simple data set for the example.

       

      Code
      DatePriceUnit
      Sales
      A1/1/2015$34$12
      A1/1/2016$46$24

       

      Here are the formulas and I created calculated fields to pull each of the variables:

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

       

      For the price change and volume change calculation, somehow Tableau always return 0 for 2016 unit and 2016 price that resulted in -$12, results below.  As for the mix change, I have no idea to why Tableau is returning $36.  Any clue?

       

      Thank you in advanced for the help!

      PVM - Calculation.png

        1 2 Previous Next