title: SSRS How to calculate Moving Range
body: <pre><code>Year    Sales   Moving Range
  2000    6461    
  2001    3459    -3002
  2002    4595    1136
  2003    9726    5131
  2004    7109    -2617
  2005    8576    1467
  2006    2962    -5614
  2007    7203    4241
  </code></pre>
  
  <p>I have a dataset similar to the above and need to calculate the Moving Range, which is Value deduct from the the previous value. This is very easy in excel. Can someone help me please Thanks a lot in advance.</p>