Help to get percentile value in MDX

Post Reply
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 » Thu Jun 18, 2009 7:10 am


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.


User avatar
jim wood
Site Admin
Posts: 3881
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA

Re: Help to get percentile value in MDX

Post by jim wood » Fri Jun 19, 2009 2:14 pm

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.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2

Post Reply