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:
All I want to do is sort the following results on the ParameterCaption column descending.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] )
Mezer_11-28_16-21-44.png
Many thanks in advance...





Reply With Quote