1 Reply Latest reply on Dec 13, 2012 10:32 AM by Mark Holtz

    T12? TTM? Trailing12? SUMIFS? Looking to chart monthly T12 sales

    Eric Johnson

      I have a large data set when I need to create a line chart showing the trailing-12 sales by month. So the value for 11/12 would be the sum of the values from 12/11 to 11/12 and the vale for 12/12 would be the sum of the values from 1/12 to 12/12, and so on.

       

      Here is the solution in Excel:

       

      =SUMIFS([Sales],[Calendar_Month_Date],"<="&[@[Calendar_Month_Date]],[Calendar_Month_Date],">"&DATE(YEAR([@[Calendar_Month_Date]])-1,MONTH([@[Calendar_Month_Date]]),DAY([@[Calendar_Month_Date]])))

       

      Please help