Moving average

[angel rivero]

Moving average

Hello guys, I've problem with MySQL and need your help.

I attach the file xlsx in the test.zip.

This file xlsx is able to calculate the moving average (column G - AVERAGE_12_MONTHS) of the column F (F_SUM).

The average is dynamic because in the column G is a line feed, e.g.:

In the cell G13 I've the average of cell F2:F13, in the cell G14 the average is of cells F3:F14, in the cell G15 the average is of cells F4:F15... etc

I need realize the same average in mysql, any suggestion?
Can you help me?
Any help would be very appreciated

http://myaccount.dropsend.com/file/0a5f969ee425f957