EvLST 
The EvLST (List property) function returns a list of unique values for a given property into a specified range of cells. The EvLST function is useful for building dynamic selection lists for user-selected expansions.
Syntax
EvLST(AppName,DimensionName,SetExpression,Target, PropertyName, ExpandDown, RepeatDuplicates)
Parameter |
Description |
|---|---|
AppName |
The current application name. |
DimensionName |
The dimension member on which you would like to base your expansion. |
SetExpression |
The string that instructs EvLST which members to return. |
Target |
The range of cells where the results are written. |
PropertyName |
(Optional) The name of the property for which to list the values. The default value is ID. |
Example
The following example returns the currency for WorldWide1 and all its children.
=EVLST("Finance","Entity",EVSET("WorldWide1","SELF_AND_BEFORE",99,TRUE,), J21:J28,"RptCurrency",TRUE,FALSE)