Cumulative MAT in table/chart

[#1]

Hi guys,

I need to have a column in this table that calculates MAT for each of the months.

So, in the March 2013 line of this table I need the sum of April 2012 to March 2013 and in the February 2013 I need the sum of March 2012 to February 2013.... and so on.

This table has data until 2010, but in the table/chart I only need the last 13 months.

Thank you in advance.

Kind regards,

Nuno

[bbi_mba_76]

Hi,

you could have a look at this document Calculating rolling n-period totals, averages or other aggregations

[#3]

Thanks. It seems it can only be solved by an AsOf table.

If someone has a different solution using a single expression directly in chart, I would really appreciate it.