Average of sales por month

[#1]

Hello friends,

I need your help. I need show average of sales por month. But the average have that considerate the month and 11 month ago. Dimension is month of year 2015

Year	Month	Sales(Uni)
2014	1	120
2014	2	130
2014	3	150
2014	4	80
2014	5	90
2014	6	100
2014	7	110
2014	8	140
2014	9	130
2014	10	160
2014	11	170
2014	12	180
2015	1	130
2015	2	150
2015	3	140
2015	4	110
2015	5	80
2015	6	110
2015	7	140
2015	8	120
2015	9	140
2015	10	180
2015	11	200
2015	12	210

Expected Result:

Jan	Feb	Mar	April	May	June	July	Agu	Sep	Oct	Nov	Dec
131	133	132	134	133	134	137	135	136	138	140	143

thanks for your help

[sunny_talwar]

Would it be possible to share your .qvf file?

[#3]

Of course.

[#4 · Accepted solution]

Thanks so much friend and got what he wanted. This is the final expression.

Only({<Year = {$(=Max(Year))}>}Aggr(RangeAvg(Above(TOTAL Sum({1} Sales), 0, 12)), Year, MonthName))