EPMSelectMember Property Range

[Former Member]

Hello

Wondering if you can help. I am trying to achieve 2 things using the EPMSelectMember formula with dimension TIME.

The aim is to have the user double click on a specific cell that then opens up the EPM - Member Selector pane and then they select a TIME that is restricted to a certain range (e.g. 2006.01 to 2025.12).

Going a step further I really want to have two separate cells (one for year and other for month), restrict both cells to a range and do this using the EPMSelectMember formula. Right now, I can restrict it to only one year or say one month in the EPM formula. Is there say an AND / OR option that combined with property and restricts to a range?

Hope this has made sense.

Thank you in advance,

Dru

[former_member186338]

Requirements not clear...

But OR can be used like here:

=EPMSelectMember(;"2017.01";"YEAR=2015;YEAR=2016;YEAR=2017";"TIME";FALSE)

";" = "OR"

P.S. You can't use:

">","<"...

YEAR=2015,2016,2017 (multiple values)