8 Replies Latest reply: Apr 14, 2017 8:39 AM by Robin Hausdörfer RSS

    Rolling 12 Mths In Script or Expression?

    Dermot mcgoldrick

      I have data running back around 4 or 5 years.  I want to show the rolling 12 month totals for a measure for the last 15 months.  I have a pretty standard Calendar Script, and can get this working to a point, however the aggregation is correct for the most recent month but then wrong by increasing measure for each month backwards.

       

      I'm trying to replicate the table below from Excel, again suspect will have to use a pivot table, hence cant use Accumulation to my knowledge?

       

      QV Query.JPG