min value using indirect set analysis

[#1]

Hi all,

Hopefully this is an easy one.....

My dimensions are:

Year (2009, 2010 etc.)

Year & Month (2009 Jan, 2009 Feb etc.)

Year & Month_mm (2009 01, 2009 02 etc.)

When a user selects from Year, I want the min of Year & Month to be displayed. I can't use min(Year & Month) because it's a text field, I can't use minstring(Year & Month) because it always returns xxxx Apr.

Is it possible to use indirect set analysis using the min of Year & Month_mm but return the value from Year & Month?

I'm having a complete mind-block on this one so hopefully someone will provide the solution.

Many thanks.

[#2]

=ONLY({1<[IPSM Year & Month_mm] = {'$(=min([IPSM Year & Month_mm]))'}>} [IPSM Year & Month])