How to show last 3 months average in straight table?

[daisy1438]

Hi  all,

can you tell me how to achieve the below requirement. 

Avail Fields: Month, Sales.

Required Output: AvgSales 

example--

for jan it showing jan sales

fer feb it showing jan+feb average sale

for mar it showing jan+feb+mar average sale

for Apr it showing feb+mar+Apr average sale

please help me on that.

Thanks

[vunguyenq89]

Hi, you can use the following expression:

=RangeAvg(Above(Avg(Sales),0,3))

Hope this helps,

BR,

Vu Nguyen

[daisy1438]

not working

[Saryk]

It has to be ordered by month. 

[Saryk · Accepted solution]

Perhaps try this also, still ordering by date.

=RangeAvg(Above(Sum(Sales),0,3))