title: Is it possible to show movement when using the RANK function in MDX?
body: <p>I have written the MDX:</p>
  
  <p><code>WITH SET [AgentLeagueTable] AS
      ORDER([Agent].[Agent Hierarchy].[Agent Name].MEMBERS,
            [Measures].[Profit],
             BDESC)
      MEMBER [Measures].[Rank] AS
      RANK([Agent].[Agent Hierarchy].[Agent Name].CURRENTMEMBER,
           [AgentLeagueTable])
    SELECT
      {[Measures].[Agent Rank on Profit], [Measures].[Bkg Profit]} ON 0,
      {[AgentLeagueTable]} ON 1
    FROM
      [TestCube]</code></p>
  
  <p>to rank agents by profit and was just curious to know if there was any MDX that could be added, or used to create a new cube measure, that allowed me to show the movement of an agent's position. For example, if an agent dropped 2 places I would like to represent this in a third column as -2 or if they moved up 3 then +3 etc. </p>