[FONT="] I have this sort of table below and I'd like to calculate percentile 80 to "qtd/cons" for each category in "Col1" as a calculated column. [/FONT]
[FONT="] [/FONT]
[FONT="] Col1 qtd cons qtd/cons[/FONT]
<tbody style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit; margin: 0px; outline: 0px; padding: 0px;">
</tbody>[FONT="] [/FONT]
[FONT="]The nem column should looks like this [/FONT]
[FONT="] [/FONT]
[FONT="]Col1 qtd cons qtd/cons Perc80[/FONT]
<tbody style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit; margin: 0px; outline: 0px; padding: 0px;">
</tbody>
[FONT="] [/FONT]
[FONT="] Col1 qtd cons qtd/cons[/FONT]
A | 20 | 25 | 0,80 |
A | 12 | 15 | 0,80 |
A | 8 | 26 | 0,31 |
A | 10 | 24 | 0,42 |
B | 19 | 20 | 0,95 |
B | 19 | 14 | 1,36 |
B | 7 | 17 | 0,41 |
C | 18 | 21 | 0,86 |
C | 8 | 18 | 0,44 |
C | 17 | 25 | 0,68 |
D | 5 | 15 | 0,33 |
<tbody style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit; margin: 0px; outline: 0px; padding: 0px;">
</tbody>
[FONT="]The nem column should looks like this [/FONT]
[FONT="] [/FONT]
[FONT="]Col1 qtd cons qtd/cons Perc80[/FONT]
A | 20 | 25 | 0,80 | 0,8000 |
A | 12 | 15 | 0,80 | 0,8000 |
A | 8 | 26 | 0,31 | 0,8000 |
A | 10 | 24 | 0,42 | 0,8000 |
B | 19 | 20 | 0,95 | 1,1943 |
B | 19 | 14 | 1,36 | 1,1943 |
B | 7 | 17 | 0,41 | 1,1943 |
C | 18 | 21 | 0,86 | 0,7863 |
C | 8 | 18 | 0,44 | 0,7863 |
C | 17 | 25 | 0,68 | 0,7863 |
D | 5 | 15 | 0,33 | 0,3333 |
<tbody style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit; margin: 0px; outline: 0px; padding: 0px;">
</tbody>