title: How to query cumulative sum period by month
body: <p>I have an issue with table source like this:</p>
  <p><a href="https://i.stack.imgur.com/UCkV3.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/UCkV3.png" alt="enter image description here" /></a></p>
  <p>Available month in table is only as is from column month, no April, May, June etc.</p>
  <p>I need to create a view to create &quot;Year to Date&quot; table as shown here:</p>
  <p><a href="https://i.stack.imgur.com/gjgrO.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/gjgrO.png" alt="enter image description here" /></a></p>
  <p>I need to view all months from Year 2020 January - December with value  based on table source.</p>
  <p>VALUE COLUMN filled by Source with same month, but because April not available from source, so it automatically gets set to 0 and others are same</p>
  <p>For CUMULATIVE VALUE COLUMN filled by value Sum from last month value</p>
  <p>I've tried using case when query but it not simple if I have to many Name and not dynamic</p>