Can anyone give me a solution for the foll:

My MDX query is something like this:

SELECT {[Customer].Levels(1).members } ON COLUMNS,
{[PERIOD].Levels(1).members } ON ROWS

the customer dimension levels(1) is the state names so the result displays all the loan values for all the states for the year 1999,2000,2001.

How can i apply a rank function on the above MDX. so that i can rank all the states based on the cumulative loan values for all the years.

Any Ideas?