Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i need to display 24 Rolling Months from last month of data as a field "RollingMonth"..
Please help me..
In Master calendar use
For Rolling 24 months:
If( YourDateFieldHere > monthstart(addmonths(today(),-22)) and YourDateFieldHere <= Today(),1) as [Rolling 24],
For Last Month:
if(InMonth(YourDateFieldHere, today(),-1), 1, 0) as LastMonthFlag,
and in front end use a Set Analysis function
sum or count as per your requirement and({<[Rolling 24],LastMonthFlag={1}>}.......)