Can any one help to do this expression as dynamic...

[#1]

Hi Experts,

I have challenge can any one pls help here....

i want feb month data based on 

Jan, Dec, Nov and this has to be Dynamic when the months get added...

I just tried as Static like this...

(Sum({<NumMonthYear ={'Jan 2014','Dec 2014','Nov 2014'} >} COUNT))/3)

Thanks in advance...

Regards,

Raja.

[sibideepak]

Hi RSRMachireddy,

Do it Dates ,

Sum({<Date={">= $(=Date(Addmonths(MonthStart(Max(Date)),-3))) <= $(=Date(MonthStart(Max(Date))))"}>} COUNT)/3