Moving avg by each month with in Quarter

[grajmca_sgp123]

Hi Team,

I have a requirement to find moving avg value by each month within quarter.

Below is sample data with expected output of Moving Avg of output field. Can you please help me with solution.

Reporting_date	Amount	Qtr-Start	Moving Avg(Output value)
25-Mar	100	1-Jan	100
31-Mar	120	1-Jan	110
4-Apr	105	1-Apr	105
10-Apr	107	1-Apr	106
31-Apr	109	1-Apr	107
4-May	130	1-Apr	112.75
29-Jun	119	1-Apr	114
30-Jun	122	1-Apr	115.33
1-Jul	101	1-Jul	101

Thank you

[MayilVahanan · Accepted solution]

HI

Try like below
Dim: Qtr-Start
Dim2: Reporting_date
Exp1: Sum(Amount)
Exp2:RangeAvg(Above(Sum(Amount),0, RowNo()))