Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi RSRMachireddy,
Do it Dates ,
Sum({<Date={">= $(=Date(Addmonths(MonthStart(Max(Date)),-3))) <= $(=Date(MonthStart(Max(Date))))"}>} COUNT)/3