SQL server - Using self join/Inner join get the data by adding all the above rows data : I need urgent help with reference to SQL server, the query details is as mentioned below:

Need to get the calculative column whose result will be addition of all the above rows. And I can't use correlated queries, Lag and Lead as it is not supported. 
I tried using Selfjoin/inner join/left outer join, the only problem I am facing is due to group by clause of other columns the result is not coming as expected..

For example,

Data is like
[Data is like this image][1]

Expected Output
[Expected output is like this image][2]

But the output I am getting due to group by clause applied on Column4
[Output getting is like][3]

Please let me know some alternative of GROUP by clause or other alternative.
Your quick help will be much appreciated.

Thanks,


  [1]: https://i.stack.imgur.com/auM2D.png
  [2]: https://i.stack.imgur.com/CFEzw.png
  [3]: https://i.stack.imgur.com/ADTxi.png