Return to: Calculated Member Builder Function List
Toggles the drill state of members. This function is a combination of DrillupMember and DrilldownMember.
ToggleDrillState(«Set1», «Set2»[, RECURSIVE])
Toggles the drill state of each member of «Set2» that is present in «Set1». If a member m of «Set2» that is present in «Set1» is drilled down (that is, has a descendant), DrillupMember(«Set1», {m}) is applied. If it is drilled up (that is, there is no descendant of m that immediately follows m), DrilldownMember(«Set1», {m}[, RECURSIVE]) is applied to Set1. The optional RECURSIVE flag is used if ToggleDrillState was called with RECURSIVE.