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))
];