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:
The formulas are as follow and a calculated field has been created for each variable:
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!