
1. Re: what is the difference between percentage of total and percentile in Quick table calculation?How percentile works?
Jonathan Drummey Aug 16, 2016 6:14 AM (in response to CHENNA YENUGA)2 of 2 people found this helpfulFirst, read this: Percentile  Wikipedia, the free encyclopedia
Given a data set of values:
2
3
3
4
8
The % of total will be SUM([Value])/TOTAL(SUM([Value])), so the given value divided by the 2+3+3+4+8 = 20, so the results of a % of total will be:
10%
15%
15%
20%
40%
Whereas the percentile table calculation is using RANK_PERCENTILE(SUM([Value])) and returns the "position" of the value. The way I like to think of this is that if I make an ordered line of values going from the lowest to the highest 2,3,3,4,8 then I'm going to split that into evenlyspaced segments. The middle value is the median and that's the 50th percentile, in this case there are 5 values so the median is the 3rd value and that is 3. So anything with a 3 is 50th percentile. Using this data set Tableau returns:
0%
50%
50%
75%
100%
Tableau also has a WINDOW_PERCENTILE() table calculation function that returns the value for a given percentile (so it's the inverse of RANK_PERCENTILE), and a PERCENTILE() function that is like WINDOW_PERCENTILE() but as a regular aggregate measure.
Jonathan

2. Re: what is the difference between percentage of total and percentile in Quick table calculation?How percentile works?
CHENNA YENUGA Aug 16, 2016 8:16 AM (in response to Jonathan Drummey)1 of 1 people found this helpfulHi Jonathan,
Thank You.
ChennaYenuga.