Hello,
In SQL I just put "Order By {whateverfield}" at the end my statement, but in MDX I just can't work it out.
I know about "ORDER" and the DESC or BDESC, but can't fit it into the following without breaking it or it having no effect:
Code:
WITH
MEMBER [Measures].[ParameterCaption]
AS[Financial Date].[Short Year-Month (H)].CURRENTMEMBER.MEMBER_CAPTION
MEMBER [Measures].[ParameterValue]
AS [Financial Date].[Short Year-Month (H)].CURRENTMEMBER.UNIQUENAME
MEMBER [Measures].[ParameterLevel]
AS [Financial Date].[Short Year-Month (H)].CURRENTMEMBER.LEVEL.ORDINAL
SELECT
{
ORDER( [Measures].[ParameterCaption], DESC),
[Measures].[ParameterValue],
[Measures].[ParameterLevel]
}
ON COLUMNS
,
[Financial Date].[Short Year-Month (H)].CHILDREN
ON ROWS
FROM
( SELECT
( { [Head Count].[Employee Status Code (H)].[Employee Status Code].&[A] } )
ON COLUMNS
FROM
[Fact Head Count]
)
All I want to do is sort the following results on the ParameterCaption column descending.
Mezer_11-28_16-21-44.png
Many thanks in advance...