how to get Maximum value

[joukz]

Hello,
I have the following MDX query :

SELECT NON EMPTY { [Measures].[Maximum Duration - Fact Event Duration] } ON COLUMNS, NON EMPTY { ([Dim Event Processing].[Case].[Case].ALLMEMBERS * [Dim Event Processing].[Dim Event Processing].[Dim Event Processing].ALLMEMBERS ) } ON ROWS FROM [FISDW] WHERE ( [Dim Date View].[Date].&[2008/12/21] )

This gives me a result like this:

Resolution 89 27
Resolution 90 27
Resolution 93 18
Resolution 98 0
Resolution 102 18
Resolution 105 0
Resolution 112 0
Resolution 113 48
Response 254 11
Response 255 14
Response 974 20
Response 978 381
Response 979 11
Response 989 21
Response 992 526
Response 993 13
Response 1038 14
Response 1039 24

The first column being the Case, the second column is the [event processing] and the last column is the [Maximum Duration - Fact Event Duration].

Can anyone help me find a way to retrieve the maximum value of the last column within the first group: basically what's the MDX query in order to have the following result:

Resolution 113 48
Response 992 526

thanks,


-