DrillupLevel

Return to: Calculated Member Builder Function List

Drills up the members of a set that are below a specified level.

Syntax

DrillupLevel(«Set»[, «Level»])

Remarks

If «Level» is not specified, it is assumed to be one less than the level of the lowest level member in «Set».

Example

DrillUpLevel({USA, CA, [Los Angeles], WA, Seattle, Canada, BC})

returns the set

{USA, CA, WA, Canada, BC}

and

DrillUpLevel({USA, CA, [Los Angeles], WA, Seattle, Canada, BC},[Store Country])

returns the set

{USA, Canada }.