2 Replies Latest reply: Nov 21, 2013 4:20 AM by Nuno Faustino RSS

    Cumulative MAT in table/chart

    Nuno Faustino

      Hi guys,

       

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

       

      Screenshot - 20_11_2013 , 19_06_31.jpg

       

      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