This is my query

WITH
SET [Recent24Months] AS 'Tail(NonEmptyCrossJoin([FY
Period].[Month].Members), 24)'
MEMBER [Measures].[Month] AS 'Rank([FY Period].CurrentMember,
[Recent24Months]) - 23'

SELECT
{[Measures].[Month], [Measures].[Country SOM]} ON 0,
NONEMPTYCROSSJOIN({[Local Price Sector].[Local Price
Sector].Members}, [Recent24Months]) ON 1
FROM [Channel Cube Monthly]
WHERE [Country].[Country].[UK]

My Problem is that my [Local Price Sector].Members have the Names High,
Medium and Low and I want them displyed in that order in my SQL Report.

So, Basically I need to add another MEMBER Thats assigns a 1 to "High",
a 2 to "Medium" and a 3 to "Low". This way I can sort by this Measure

Can anyone give me advice on how to do this

Thanks in advance

Denver

WITH MEMBER [Measures].[SortMember] AS 'IIF([Local Price
Sector].CurrentMember.Properties("Caption") = "High", 1, IIF([Local Price
Sector].CurrentMember.Properties("Caption") = "Medium", 2, 3))

"Denver" <DenverKirrane (AT) gmail (DOT) com> wrote

Magnificent

Thanks

DK