7 Replies Latest reply on Feb 25, 2019 12:08 PM by Russell Goldin

    Running Sum 12 Months With Prior 12 Months Data


      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?