Order

Sorts members of a set in order based on an expression.

Syntax

Order ( set, string_expr | numeric_value_expression [,BASC | BDESC] )

Notes

This function ignores missing values.

Example

The following query displays budgeted Sales and Marketing in Qtr2, and the display of products is sorted based on ascending Actual Sales in Qtr1.

SELECT
 CrossJoin(
           {[Scenario].[Budget]}, 
           {[Measures].[Marketing], [Measures].[Sales]}
          )
ON COLUMNS,
 Order(
        [Product].Levels(0).Members,
        ([Year].[Qtr1], [Scenario].[Actual])
      ) 
ON ROWS
FROM Sample.Basic
WHERE ([Year].[Qtr2])

This query returns the grid: