title: Add Data of previous months in next month,Historization of data in SAP HANA Calculation View
body: <p>Historization means we show add data of previous months to upcoming months.</p>
  
  <p>For eg: Input:</p>
  
  <pre><code>ID  STATUS  YEAR MONTH
  A   OPEN    2017-01
  A   CLOSED  2017-03
  B   OPEN    2017-01
  B   Closed  2017-05
  </code></pre>
  
  <p>My O/P:</p>
  
  <pre><code>YEAR MONTH     COUNT-OPEN                         COUNT-CLOSED
  2017-01     2(both A &amp; B OPEN)                      0
  2017-02     2(FROM 201701)                          0
  2017-03     2(from 2017-02)-1(A Closed now)=1   1
  2017-04     1(from 201703)=1                    1(from prev month)
  2017-05     1-1(b closed)=0                     1+1(b closed)=2
  </code></pre>
  
  <p>Values are the actual o/p I have just written the formula to make you understand the logic.
  I need to add data to open/ Closed from prev months to upcoming months, is it possible in SAP HANA W/O use of Cursors?
  As I can do it with Cursors, If any other logic exist please help me with it!</p>