Multiple expansion execution order
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?