3 Replies Latest reply on Apr 11, 2017 10:06 AM by Jim Dehner

    Rolling Sum of 4 Quarters

    Molly McGrory
    Molly McGrory Mar 20, 2017 10:39 AM

      Attached is a workbook where I would like to be able to calculate a Rolling Sum of the Qty column. I want to be able to have the rolling sum be the most recent 4 quarters and then be able to compare to the previous four quarters. Does anyone know if this is possible or how to approach it?

       

      Thank you!