Getting Max() from Alternate States selection

[Anonymous]

Hi there,

I am using Max(Year) and Max(Year)-1 to get the year and the previous your from my selection.

Now I need the Max(Year) and the Max(Year)-1 from an Alternate State selection.

I need them in my expression. Any idea how this expression would look like?

Thank you all.

Dennis.

[nagaiank · Accepted solution]

Did you try

Max( { [AlternateState] } Year)

[Anonymous]

Thanks that is it, I got lost in way to many < $:: > )( [ ] { }'s  🙂