Sometimes, you need to limit the members to those with data. To do this, you can specify hierarchy/member pairs for which data must exist.
For example, you may want the last date where data exists. To do this, you could add a measure to an XL3MemberNavigate on the LastMember of a level.
For example:
=XL3MemberNavigate(1,"[Date].[Calendar]","[Date].[Calendar].[Date]","LastMember")
- August 31, 2004
=XL3MemberNavigate(1,"[Date].[Calendar]","[Date].[Calendar].[Date]","LastMember", 1, "[Measures]", "[Measures].[Reseller Sales Amount]")
- June 1, 2004
