Need help on calculated dimensions

[ananyaghosh]

Hi,

I need help on calculated dimension. I need to get max year in my calculated dimension and for that reason I have used the below expression:-

{Year=<=max(Year)>}Year

and also I need previous year as a calculated dimension:-

{Year=<=max(Year)-1>}Year

but it gives me an error.

please help me to solve this.

Thanks,

Sandip Ghosh

[sunilkumarqv]

hi Sandip,

Create synthetic  dimension use of  variable

PLz check attached

[#3]

Hi,

You have asked for current year and previous year.....

"

I need help on calculated dimension. I need to get max year in my calculated dimension and for that reason I have used the below expression:-

{Year=<=max(Year)>}Year

and also I need previous year as a calculated dimension:-

"

Please give your actual requirement..