6 Replies Latest reply on Oct 15, 2013 1:43 PM by gall3on

    Running Sum 12 Months With Prior 12 Months Data

    gall3on

      I'm trying to put together a financial dashboard.  One of the requirements is to graph a cumulative 12 month revenue sum month over month.  Part of me thinks this is a windowed table calculation but I can't figure out how to just count the 12 months I need to add up.

       

      Essentially for a specific month row, I have to show the cumulative prior 12 month sum of revenue.  My data set currently only has the gross revenue per month.

       

      For example:

       

      Nov 2012 will a running 12 gross profit sum of Dec 2011 to Nov 2012 to

      .

      .

      .

      October 2013 will have a running 12 sum of Nov 2012 to Oct 2013

       

      How can I create this calculation?