4 Replies Latest reply on May 31, 2016 12:01 PM by vinutha vasanthu

    How to calculate the Rolling Sum for 3 months

    vinutha vasanthu

      My requirement is I need to calculate the Rolling Previous Month from the current month

      I could figure out on how on the months we need to fetch based on the filter which is working as expected.

      Now i hit the dead end....

       

      • I Need 30,60,90 Sum per LOB. instead of 30,60,90 to be a drop down.
      • Also for 60 days its is showing as 2 months(for 11/17/2015 the Rolling Months is October and November)
      • I need sum of Oct and Nov to be displayed as one in 60 days.Added to this i need 30,60,90 as bars per LOB on selecting the Date.
      • Is there a way to use Month(dimension) as a selection criteria instead of parameter(DateParam).
      • Also i am not able to see the  data for current month i.e 30 days

       

      This is the calculation i used.

      CASE [TimeFrame]

      when 'DateMonth' then if [Months between today and Date]=0 then 'show' end

      when 'Last2Months' then if [Months between today and Date]>=0 and [Months between today and Date]<=1 then 'show' end

      when 'Last3Months' then if [Months between today and Date]>=0 and [Months between today and Date]<=2 then 'show' end

      else 'hide'

      end