Dear all,

I want to sort a list of supplier according to their sales amount in
descending order. Then, the rank of the currentmember is shown as a
calculated member. Does anyone know how to write the MDX?

Thanks!

Polly

Create a ordered set. Then create a calculated member using the Rank
function. Here's an example from the Foodmart sample.

WITH SET [Ordered Suppliers] AS '
{ Order( Filter ( { [Customers].[Name].Members }, NOT IsNull(
([Measures].[Store Sales]) )) , ([Customers].CurrentMember,
[Measures].[Store Sales]), DESC) }
'
MEMBER [Measures].[Sales Rank] AS '
Rank ( [Customers].CurrentMember, { [Ordered Suppliers] })
'
SELECT { [Measures].[Store Sales], [Measures].[Sales Rank] } ON COLUMNS,
{ [Ordered Suppliers] } ON ROWS
FROM [Sales]
WHERE ( [Time].[1997])

"Polly" <Polly (AT) discussions (DOT) microsoft.com> wrote

Thanks! Martin.

"Martin Mason" wrote: