Skip to Content
0
Former Member
Apr 13, 2010 at 01:23 AM

Multiple expansion execution order

59 Views

Hi,

I have an EVDRE report which column memberset is defined by the result of an EVENE function.

Say that the user sets a year in a cell. I would then use an EVENE to retrieve the list of all subsequent years and concatenate the result to use it in the EVDRE memberset.

How can I ensure that the EVENE will be executed before the EVDRE in the expansions sequence?

Basically, when one has more than one expansion functions in a worksheet and they are interdependent, how do we control the execution sequence?

Thanks

Regis