create dynamic dimension

[Anonymous]

i have the following dimension

LOAD * INLINE [

  Period,Column

  Month,Actual Mth

  Month,Budget Mth

  YTD,Actual YTD

  YTD,Budget YTD

  YTD,Variance YTD

];

Is the a way to add year selection in the dimension

LOAD * INLINE [

  Period,Column

  Month,Actual Mth(max (year))

  Month,Budget Mth(max (year))

  YTD,Actual YTD(max (year))

  YTD,Budget YTD(max (year))

  YTD,Variance YTD(max (year))

];