Rolling Total for 3 rows prior data including present row

[ramatp30]

Hi All

For one of my use case i need to have 4 quarters sum.For any given row i need to have sum off 3 prior quarters or rows including present row.

How can i do that.

Below excel table will give more information about my usecase.

Any help is much appreciated. 

Quarter	Commencements_Total	RunningTotal(4Rows)
Sep-84	0
Dec-84	0
Mar-85	0
Sep-84	10676	10676
Dec-84	9885	20561
Mar-85	8419	28980
Jun-85	10987	39967
Sep-85	10707	39998
Dec-85	9093	39206
Mar-86	8076	38863
Jun-86	8061	35937
Sep-86	9171	34401

[BenMoss · Accepted solution]

Hi!

Check out the multirow formula tool which will allow you to acheive this.

You can set up a formula along the lines of...

[Row-3:Commencements_Total]

+

[Row-2:Commencements_Total]

+

[Row-1:Commencements_Total]

+

[Commencements_Total]

And if you want the new column to be NULL() when you are creating this calculation then set the drop down 'Values for rows that don't exist' to NULL

Ben

[ramatp30]

Thank you @BenMoss it worked!!