ancestors

Returns all the ancestors of "member" at "level" or "index" distance above the member. (Most data sources support only one ancestor at a specified level. If the data source supports more than one ancestor, the result is a member set.)

Syntax

ancestors ( member , level|index )

Example 1

ancestors ( [TrailChef Water Bag] , 1 )

Result

Cooking Gear

Example 2

ancestors ( [TrailChef Water Bag] , 2 )

Result

Camping Equipment

Example 3

ancestors ( [TrailChef Water Bag] , [great_outdoors_company].
[Products].[Products].[Product type] )

Result

Cooking Gear