Page 1 of 1

Help to get percentile value in MDX

Posted: Thu Jun 18, 2009 7:10 am
by idanh79
Hi,

I would really appreciate if anyone could give me a MDX statement that
returns percentile value. For example, the 90th percentile of store sales.
Please do not point me to using Excel.

Thanks,
Idan

Re: Help to get percentile value in MDX

Posted: Fri Jun 19, 2009 2:14 pm
by jim wood
When you say MDX do you mean within Analysis services? I have guessed as much and moved this post. If you do not mean Analysis Services then I will move it appropriately depending on the MDX solution you are using.