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...