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: 3952
- 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
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
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7