Average from several records

[PavelKas]

Hello,

Let's say I have a table with two fields - Date and Sales. I want to add the third column, which is the average of Sales related to 10 dates that are equal or less than the Date in the first column.

Thanks for the help

[Oliver_F]

So you want to have a rolling average for the last 10 rows of the Sales column? I think you might want to use the avg(above()) combination for this.

[PavelKas]

Thank you Oliver! It is a good idea! I will try