I would like the use one of the T#Global function and create a dynamic time list for the last 24 months. For example, I had the time as 2023M12, the list would show me all the months of 2023 and 2022. Anyone has any tips on how this can be acoomplished?
Trung
T#YearPrior1(|GlobalTime|)Period(|GlobalTime|).Prior11, T#Global.Prior12, T#Global
Let's examine it from the end. T#Global will be our current Global period, easy. Then we add the previous 12 periods with .Prior12. That gives us 13 months, so we want the previous 11; to do that, we "rollback" to the same period (e.g. Dec) in the previous year, with T#YearPrior1(|GlobalTime|)Period(|GlobalTime|), and we use that as a reference to get the previous 11 periods.
This will give you the previous 24 periods inclusive.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.