1 of 1 people found this helpful
It is a little difficult for me to tell exactly what is going on in the workbook from the attached screen shot. If you could provide a sample workbook I would be happy to look into more detail on the issue. But, here is some general information on the use of the %difference equation: http://onlinehelp.tableau.com/current/pro/online/windows/en-us/help.html#calculations_tablecalculations_definebasic_diff…
As well as some definitions of the basic Table calculations we have to offer: http://onlinehelp.tableau.com/current/pro/online/windows/en-us/help.html#calculations_tablecalculations_definebasic.html…
Table calculation does not support Table calc x Table calc in this case.
So, "% of Total Value along Table (Down)" should be calculated by formula, not table calculation,
Then, that field can be used for "next" table calculation of "Difference from previous:"
[Value % of TTL] // % down the pane.
Tablecalc_x_tablecalc_9.0.twbx 27.7 KB
Patrik and Shin
Thanks a lot for your replies. Those replies answered to my question and I could finally implement % of difference of the values.
Happy to hear so.
Just one more request, could you mark "Correct answer" for other community people to know it's answered.