How to get the min Period of the max Year by using Set Analysis?

[Anonymous]

For example,

There are 24 periods, 200901,200902,.........200912,201001,201002,........201012

I want to get the min Period of the max Year by using Set Analysis .

1.max Year =>2010

2.min Period=>201001

How can I get it whatever selections be selected?

[Anonymous]

Supplement:

There are 3 Field, Year,Period,Sales

I want to get sum(Sales) in min Period of max Year(201001).

Expression=sum({<?>} Sales)

[edandurova]

this works for me - maybe you can simplify:

sum({$<period={$(=min({$<period=P({<year={$(=max(year))}>})>} period))}>} sales)

Evgenia

[#4]

This should work, I don't know if it's any simpler:

Sum({<Period={$(=Min({<Year={$(=Max(Year))}>}Period))}>} Sales)