Learn the application of XL3MemberNavigate in Anaplan XL
Based on the Bicycle Sales cube
Levelrelationships
These examples assume that [Time].[Year] is in cell A1
=XL3MemberNavigate( 1, "Time", A1, "FirstMember" )
- 2002
=XL3MemberNavigate( 1, "Time", A1, "LastMember", 2 )
- 2004
Member relationships
These examples assume that [Time].[All].&[2003].&[Q2] is in cell A1
=XL3MemberNavigate( 1, "Time", A1, "Parent" )
- 2003
=XL3MemberNavigate( 1, "Time", A1, "Parent", 2 )
- All
=XL3MemberNavigate( 1, "Time", A1, "Next" )
- Q3
=XL3MemberNavigate( 1, "Time", A1, "Previous", 2 )
- Q4 (from 2002)
=XL3MemberNavigate( 1, "Time", A1, "FirstSibling" )
- Q1
=XL3MemberNavigate( 1, "Time", A1, "LastSibling", 2 )
- Q3
=XL3MemberNavigate( 1, "Time", A1, "FirstChild" )
- April 2003
=XL3MemberNavigate( 1, "Time", A1, "LastChild", 2 )
- May 2003
