Rolling 15 Months Variance calculation

[#1]

Hi can any one help me to calculating rolling 15 Months Variance, means when user selects 2016 jan  my application has to show last 15 months Variance with its previous year same month.

I am attaching a qvw with some sample data , can any one help me on this.

Thanks

John

[amit_saini]

John,

Try something like below:

Sum({<YearMonth ={">=$(=Date(addmonths(Max(YearMonth), -15), 'MMM-YY')) <=$(=Date(addmonths(Max(YearMonth), -1),  'MMM-YY'))"} >} Sales)

Thanks,

AS

[Anonymous]

why not check this?

Calculating rolling n-period totals, averages or other aggregations

Set Analysis for certain Point in Time

[jagan]

Hi,

check this link for this type of similar scenarios.

Set Analysis for certain Point in Time

[#5]

Thanks amit saini,

Your expression will work for normal sales , however I need variance of sales from its previous year same month , it is not working in my case.