Page 1 of 1

MDX TOPCOUNT sort order

Posted: Mon Oct 22, 2012 2:11 pm
by holger_b
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

Re: MDX TOPCOUNT sort order

Posted: Tue Oct 23, 2012 8:31 am
by holger_b
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.