Rolling 12 Months Data

[selvakumara]

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.

[devarasu07]

Hi,

Try to create rolling 12 month flag in back end master calendar script then u can easily use anywhere at front end

  If( $(TimeField) > addmonths($(CurrentDate),-12) and $(TimeField) <= Today(),1) as _R12

Re: Rolling 12 months flag in master calendar script?

[selvakumara]

Let TimeField='YOUR DATE FIELD HERE'; ?

Need some example