11 Replies Latest reply on Feb 5, 2014 3:13 AM by Gorazd Ozimek

    Moving annual totals

    Christopher Henderson

      Hi

       

      I have a data set which shows the sales of a product by month, what I need to do is create a moving annual total by month and put these results into a table, so for example November's Moving Annual Total would be the sum of November's sales and the 11 months prior to be a full annual total. I would like to put these into a table by month and as I update the data with the latest month it populates the moving annual total table with the newest month.

       

      Would anyone know of a calculation that would help with this?

       

      I have attached a sample of my data in a workbook.

       

      Many thanks

       

      Chris