Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Please help me for this I tried to a lot for this but still I am in trouble to find the average of Rolling last 18 months data. Because when we fetch the data for current year rolling 18 months data it works fine and when I find separately previous year data then also it gives correct output but when I try to compare between them it gives wrong output. Because the current Year rolling month July 2012 matched by previous year July.
SET vMaxYear=MAX(Year)
Sum
({<Year={$(vMaxYear)},Month={"$(=Max({<Year={$(vMaxYear)}>}Month))"}>} Value) //Currentyear currentMonth
Sum
({<Year={$(=Max(Year(Year))-1)},Month={"$(=Max({<Year={$(vMaxYear)}>}Month))"}>} Value) //PreviousYear CurrentMonth
Hope it will help u
Hi Bika
Thanks for ur Reply but Bika It is not exactly that I want. Bika I want to display only 18 Rolling months difference for example current year starts from July 2013 to Feb 2012 and Previous Year starts from July 2012 to Feb 2011.