COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Analysis Studio => Topic started by: katherine on 15 Sep 2009 05:24:24 AM

Title: Percentile,Quartile,Quantile issue in Analysis Studio
Post by: katherine on 15 Sep 2009 05:24:24 AM
I create a new crosstab as follows:

Product          2004          Percentile (2004)          Quartile (2004)          Quantile - 8 (2004)
    A      153,553,850.98            60%                           2                              4
    B       332,986,338.06           80%                           1                              2
    C       391,647,093.61           100%                         1                               1
    D       36,165,521.07             40%                           3                              5
    E                                       20%                           4                               7


I don't know it how to calculate the results of Percentile,Quartile,Quantile,or the algorithm of the Percentile,Quartile,Quantile.Would someone so kind tell me?
Thank you very much


Best Regards
Katherine



Title: Re: Percentile,Quartile,Quantile issue in Analysis Studio
Post by: katherine on 26 Sep 2009 09:50:37 AM
I figure out the algorithm of them :)