I am using order function in a MDX query to get the member values of a dimension in Alphabetical order - A to Z. This dimension member is one of the parameter of my report.
But there is a challenge. I have data like
So now as it is working in Ascending order format. Data is show like this in the Drop down list box.
I want to achieve the order like this, irrespective of the names. The All values has to be displayed first in the drop down menu of parameter.
Please suggest any suitable MDX based solution ?
Thanks in advance.