Return to: Calculated Member Builder Function List
Drills down the top N members of a set, at a specified level, to one level below.
DrilldownLevelTop(«Set», «Count»[, [«Level»][, «Numeric Expression»]])
DrilldownLevelTop functions like DrilldownLevel does, but instead of including all children for each member at the specified «Level», only the top «Count» number of children are returned, based on «Numeric Expression».
Assuming CA and NY had the highest sales,
DrilldownLevelTop({[Customers Location].USA},2,,[Unit Sales])
returns the set
{USA, CA, NY}.
The expression
DrilldownLevelTop({[Customers Location].[Country].Members},2,,[Unit Sales])
returns the set
{Canada, <top two provinces in Canada>, Mexico, < top two states in Mexico>, ..., USA, < top two states in USA>}.