
1. Re: How to calculate %Difference of Measured Values
patrick.byrne.0 Feb 22, 2016 1:53 PM (in response to Shuta Sato)1 of 1 people found this helpfulShuta,
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/enus/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/enus/help.html#calculations_tablecalculations_definebasic.html…
Regards,
Patrick

2. Re: How to calculate %Difference of Measured Values
Shinichiro Murakami Feb 22, 2016 2:12 PM (in response to Shuta Sato)Shuta
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.
sum([Value])/attr({fixed[Unit Name]:sum([Value])})
Thanks,
Shin
9.0 attached.

Tablecalc_x_tablecalc_9.0.twbx 27.7 KB


3. Re: How to calculate %Difference of Measured Values
Shuta Sato Feb 22, 2016 5:04 PM (in response to Shinichiro Murakami)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.
Sincerely,
Shuta

4. Re: How to calculate %Difference of Measured Values
Shinichiro Murakami Feb 22, 2016 6:59 PM (in response to Shuta Sato)Shuta,
Happy to hear so.
Just one more request, could you mark "Correct answer" for other community people to know it's answered.
Thanks,
Shin