WITH




SET [RDate] AS [RDate].[Date].[Date].ALLMEMBERS
set [Title] as [Title].[Studio].[Studio].ALLMEMBERS

SELECT non empty([Measures].[OrderQty]) on columns,
non empty( [RDate] *[Title] * 
  ( TopCount
    (
      Order
      (
         [Title].[Format-Titles].[Name].MEMBERS
       ,[Measures].[OrderQty]
      ,DESC
      )
     , 10
    )
  ) ) ON rows
      FROM [MainCube]
  where ({[Date].[Date].[2015-08-09]:[Date].[Date].[2015-08-16]})


  above query is to get , top 10 title for given period,  getting result what i want but trying to order by [Measures].[OrderQty],

  result what i am getting is order by [RDate]

  how to change above query to order by [Measures].[OrderQty]

Thanks

V