ratio in rolling 12 seta nalysis

[bruno_m_santos]

Hi all,

I need to  make a ratio in a rolling12 seta nalysis between first value of the range (newer) and the last one (older)

Any idea to do that?

Many Thanks for your help

Bruno

Sum
({Real*$(vMeasure)* $<MonthID =  {">=$(=Max(MonthID) - 11)<=$(=Max(MonthID))"},
Date = {"<=$(=Max(Date))"},
Year =,
Quarter = ,
Period = ,
[Period (#)] = ,
Month = 
>}QTD)/
Above(
Sum
({Real*
$(vMeasure)* $<MonthID =  {">=$(=Max(MonthID) - 11)<=$(=Max(MonthID))"},
Date = {"<=$(=Max(Date))"},
Year = ,
Quarter = ,
Period = ,
[Period (#)] = ,
Month = 
>}QTD)) 

[bruno_m_santos]

I found solution.

This is the best way?

Thanks

Bruno

=Sum
({Real*$(vMeasure)* $<MonthID =  {">=$(=Max(MonthID) - 11)<=$(=Max(MonthID))"},
Date = {"<=$(=Max(Date))"},
Year =,
Quarter = ,
Period = ,
[Period (#)] = ,
Month = 
>}QTD)/
/Sum({Real*$(vMeasure)* $<MonthID =  {"$(=min({Real*$(vMeasure)* $<MonthID =  {">=$(=Max(MonthID) - 11)<=$(=Max(MonthID))"},
Date = ,
Year =,
Quarter = ,
Period = ,
[Period (#)] = ,
Month = 
>}MonthID))"},
Date = {"<=$(=Max(Date))"},
Year =,
Quarter = ,
Period = ,
[Period (#)] = ,
Month = 
>}QTD)