-- SMDX003-004 Simple Use of Order() function across columns, 
--  sort descending(respecting hierarchies) 


SELECT 

   NONEMPTY

      ORDER(

         {[Geography].[Geography].[State-Province].[Alabama].CHILDREN,

            [Geography].[Geography].[State-Province].[Mississippi].CHILDREN},

         [Measures].[Reseller Sales Amount], DESC

      ) ON AXIS(0),

             {[Measures].[Reseller Sales Amount]} ON AXIS(1)

FROM 

   [Adventure Works]