title: Display sum from previous year
body: <p>I have select statement like below:</p>
  
  <pre><code>  select [Fiscal Year], sum([value]), 
           YEAR(DATEADD(year,-1,[Fiscal Year])) as previous_year
    from [table1] 
    group by [Fiscal Year]
  </code></pre>
  
  <p>How to add after column <code>previous_year</code>, <code>sum([value])</code> from previous year?</p>
  
  <p><a href="https://i.stack.imgur.com/uYOG0.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/uYOG0.png" alt="enter image description here"></a></p>