
1. Re: Calculate % difference of two members
Stephane Marx Jun 17, 2016 2:59 AM (in response to Lian Norliansyah)Hi Lian,
It seems you already have a good knowledge about the Tableau table calculations. A little trick I discovered is that you can dragged out your table calculations to the measure data pane. See below:
I can now rename the table calculation and make it a calculated field:
I find it super useful, it's also really convenient when you want to perform some calculations you know tableau can do, without taking the time/ risk to type them yourself!
Hope this helps,

2. Re: Calculate % difference of two members
Stephane Marx Jun 17, 2016 3:01 AM (in response to Stephane Marx)you can also use them then in parameters to allow the end user to swap between the different table calcs in the visualization

3. Re: Calculate % difference of two members
Lian Norliansyah Jun 21, 2016 11:03 PM (in response to Stephane Marx)Hi Stephane,
Thanks for your advise.
The use something like SUM([SALES]) / TOTAL(SUM([SALES])) does not work on the sample
I provided.
If I use the above logic, the TOTAL(SUM([SALES])) would be Total Ticket (10) + Ticket Delivered On Time (9) = 19.
So % of Total for Ticket Delivered On Time = 9 / 19, which it should be 9/10
Is there any other calculation I can use?
Thanks,
Lian