7 Replies Latest reply: Mar 4, 2015 4:20 AM by Sattish G RSS

    Running average of previous 3 months

    Yuvraj Killedar

      Dear all, need a bit of help on this one...

       

      I have 2 columns Month & sales.

       

      Required a third column that has average of previous three months...

      E.g.: today is 03-03-2015.

      So, previous 3 months average would include average of current month March & previous 2 months that is Jan & Feb.

       

      Also the constraint is that all the records must have the corresponding values and should change on selections.

       

      For reference attaching excel that consists of two sheets.

      One contains data & second sheet shows the required output.

       

      Kindly guide on the same...