Custom Ordering In MDX For SSRS Report

Hi guys,

i Have the following code for a SSRS Matrix Report.


SELECT NON EMPTY { [Measures].[Ordered Qty], [Measures].[Line Fill %], [Measures].[Qty Fill %], [Measures].[Delivered Qty], [Measures].[Delivered Lines], [Measures].[Ordered Lines] } ON COLUMNS,

NON EMPTY {[Customer].[Customer Name].[Customer Name].ALLMEMBERS * [Market].[Product Group].[Product Group].ALLMEMBERS * {[Time Calculations].[MTD Pr Mth],[Time Calculations].[MTD]} } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS

FROM ( SELECT ( STRTOSET(@DatePeriod, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@DateYear, CONSTRAINED) ) ON COLUMNS FROM [DIFOT]))

WHERE ( IIF( STRTOSET(@DateYear, CONSTRAINED).Count = 1, STRTOSET(@DateYear, CONSTRAINED), [Date].[Year].currentmember ), IIF( STRTOSET(@DatePeriod, CONSTRAINED).Count = 1, STRTOSET(@DatePeriod, CONSTRAINED), [Date].[Period].currentmember ) )

CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS




Parent is the Customer Name, with Drill Down to Product Group.

Is their a way that i can sort this report so the customers with the highest [Measures].[Ordered Lines] for ],[Time Calculations].[MTD] is on the top.

Ive been trying to work out the ORDER command in MDX, but i cannot seem to get it to work..

Any help would be great

Thanks
Scotty