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!
Hello - Looks like this has already been answered by Adam Crahen on the other thread you started:
Calculation Order - Price Volume Mix Calculation
Please follow that thread and close this one.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...