OBIEE 11g Moving subtractions step by step using MSUM

• Drop the same measure 3 times in the selected columns pane. (In my example i have used Revenue and order No.)
• Click the first measure and leave the formula as it is. 

•            Click on the second measure and edit the formula to:
  MSUM ("Base Facts"."Revenue", 2)-"Base Facts"."Revenue"
                   
  
  
   N<!--[endif]-->ow, click the third measure and edit the formula to :
  ("Base Facts"."Revenue" ) - (MSUM("Base Facts"."Revenue" ,2) - ("Base Facts"."Revenue" ))    
  
  
                        
  
  
  V<!--[endif]-->erify your results.