Set Analysis, Alternate States, Prior Year

[brentdej]

I am using Set Analysis (QV11) with Alternate States and am trying to get a prior year calculation. The expression below works for the selected year, and is summing for the selections in the alternate state (GroupOne) but applying the time dimension selections in the default state. I can't seem to modify this to get a prior year calculation. The Year is a character string.

sum({GroupOne<Year = $::Year, Month = $::Month>} PremiumByPolicy) * .001

Thanks in advance...

[Gysbert_Wassenaar]

Perhaps like this:

sum({GroupOne<Year = {'$(=max({$}Year)-1)'}, Month = $::Month>} PremiumByPolicy) * .001

If not, please post an example document with sample data.

[brentdej]

Thank you!

That worked perfectly.

Brent