Return to: Calculated Member Builder Function List
Returns the ancestor of a member at a specified level.
Ancestor(«Member», «Level»)
If the Geography dimension includes levels Country, State, and City, then the following functions return the following values.
| Function | Returns |
|---|---|
| Ancestor(Seattle, Country) | USA |
| Ancestor(Seattle, State) | Washington |