Dear all,
currently I work on an active report with a top 10 customers list. Works neatly, the ten top performers are sorted in descending order by turnover. But: when I expand one of them, it would be great to have the children (and grandchildren) sorted as well - did anyone ever accomplish that?
Thank you
Holger
MDX TOPCOUNT sort order
-
holger_b
- Posts: 131
- Joined: Tue May 17, 2011 10:04 am
- OLAP Product: TM1
- Version: Planning Analytics 2.0
- Excel Version: 2016
- Location: Freiburg, Germany
Re: MDX TOPCOUNT sort order
One day later: I solved it with two different MDX statements which are used depending on the state of a check box (drill on/off), that did the job.