6 Replies Latest reply: Apr 17, 2013 1:15 AM by Yang Yang RSS

    12 months rolling for multiple selection of months on one single report

    Yang Yang

      I need to have one single report that can display current month value and relevant 12 months rolling value. What I would like to achieve should look like:

      FinMonthYearMeasureMeasure 12M Rolling
      JUL-117272
      AUG-1166138
      SEP-1165203
      OCT-1191294
      NOV-11109403
      DEC-11129532
      JAN-11109641
      FEB-11136777
      MAR-1189866
      APR-1189955
      MAY-11651020
      JUN-11641084

       

      So I can have the visibility of trend for 12 months rolling.

       

       

       

      However, I can only manage to have current month value and 12 months rolling value displayed for one specific year-month such as:

       

      FinMonthYearMeasureMeasure 12M Rolling
      JUN-11641084

      If I select one MonthYear period, the rolling value is calculated correctly.

       

      But if I select multiple periods, it can only give me the rolling value for the latest month such as:

      FinMonthYearMeasureMeasure 12M Rolling
      JUL-11721084
      AUG-11661084
      SEP-11651084
      OCT-11911084
      NOV-111091084
      DEC-111291084
      JAN-111091084
      FEB-111361084
      MAR-11891084
      APR-11891084
      MAY-11651084
      JUN-11641084

       

      I have tried a lot of changes in my set analysis script but no luck. Does anyone konw how to get this work without createing a different calendar table? Many thanks in advance.