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,
you can also use them then in parameters to allow the end user to swap between the different table calcs in the visualization
Thanks for your advise.
The use something like SUM([SALES]) / TOTAL(SUM([SALES])) does not work on the sample
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?