Help to get percentile value in MDX

Post Reply
idanh79
Posts: 1
Joined: Thu Jun 18, 2009 7:08 am
Version: 2007
Excel Version: 2007

Help to get percentile value in MDX

Post 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
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Help to get percentile value in MDX

Post 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.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Post Reply