BOTTOM
Makes the last member of a result set the current member.
Syntax
BOTTOM [setname]
Parameters
setname | The name of a result set. If a setname is not specified, the current set is used. |
Example
To find all Employees with Jones as a last name, to identify the result set as KeepName, and to set the current member pointer to the last member of KeepName, enter
find all Employees where LastName = “Jones” -> KeepName
bottom KeepName
To move the current member pointer to the last member in the current set, enter
bottom