2 Replies Latest reply: Nov 22, 2017 2:31 AM by Selva A RSS

    Rolling 12 Months Data

    Selva A

      Hi Guys,

       

      I have a requirement like below.

       

      If i selected a Year = 2017 , it will display 12 months data

       

      Dimension = YearMonth (Jul-16 to Jun-17 )

       

      Expression :  RangeSum(Above(Count({$<[Group] = {'****************************'}>} DISTINCT record ), 0, 12))

       

       

      Total for the year = 190. its correct for Jun-17.

       

      But rest of the months are not correct.

       

      I want the solutions like ,

       

      For Aug16-  I wants the data from (aug15-jul@16) like for each months . As of of it was pulling like (jun16-aug16)

       

      Thanks in advance.

      1.PNG