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
Help to get percentile value in MDX
- jim wood
- Site Admin
- Posts: 3832
- 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
- Contact:
Re: Help to get percentile value in MDX
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
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2