Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have straight table which show members wise sum of Turnover.
i want to create a lable/ calulated variable which show me what is the 90 percentile of turnover value.
Member Name | SUM of Turnover | Cumm. Sum of turnover | %TILE |
ABC | 10 | 10 | 5% |
XYZ | 20 | 30 | 14% |
EDF | 10 | 40 | 18% |
NOP | 30 | 70 | 32% |
JDF | 40 | 110 | 50% |
UTY | 30 | 140 | 64% |
ORE | 20 | 160 | 73% |
YOI | 40 | 200 | 91% |
ERT | 20 | 220 | 100% |
In the above table 200 is the 90 percentile of the turnover. so this 200 should be store in a varaible.
Kindly let me know how can we do this.
Thanks & Regards,
JKV
attach your sample qvw . So that you can get correct solution.
Hi
I would need a sample from you to work out a variable, but you can do this without a variable using Dimension Limits. Select the "Show only values that accumulate to" option and enter 90%.
HTH
Jonathan
I want to store the percentile result into a variable because i want to use that varaible to create a reference line into a scatter chart.
if i am using default percentile of reference line in scatter chart then it is calculating on basis of no. of Member not on the turnover.
This is why i want to know the the turnover value on 90 %tile position when i create memberwise turnover and also i have to ensure that it will be sorted on turnover desencing order only.
If i get time i will share you the sample data because i have to create it. i can not share the live data.
Thanks all for you help.
JKV