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.