All Months in Prior Year based on Global Time

[bilbrandon]

Hello.

I am trying to create a column set showing M1-M12 for the previous year based on Global Time. I can do this successfully using WFYear and POVYear as shown:

T#YearPrior1(|WFYear|).Base
T#YearPrior1(|POVYear|).Base

However, this syntax generates an error  =>   T#YearPrior1(|GlobalYear|).Base

I can get close using  =>  T#GlobalYear.Prior1.Base
But, it adds a column for the year which we do not want:

Thanks,
Bil Brandon

[Hweeli · Accepted solution]

Hi,

try T#YearPrior1(|Globaltime|).Base