I get this error for the below code:

Query (11, 7) Parser: The syntax for 'ORDER' is incorrect.

-- 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]

What's wrong with the syntax?

TIA,

Rob