Set Analysis for Nested loop

[alkesh_sharma]

Hello,

Can anybody please tell me the set analysis statement for nested loop.

[jerem1234]

Here try this:

=mod(month(date#([Rolling Month], 'MMM - YYYY'))-4, 12)+1+(Year(addmonths(date#([Rolling Month], 'MMM - YYYY'),-3))-2005)*12

You can use this as calculated dimension or in script. You might also be able to condense this if certain fields exist and are in date format.

You might even be able to sort by the date and just use something like rowno() in the script. The way you go about it depends on how your data looks.

Hope this helps!