Analysis Services
Tail
Returns a subset from the end of a set.
Syntax
Tail(«Set»[, «Count»])
Remarks
This function returns the last «Count» elements in a set. The order of elements is preserved. The default value of «Count» is 1. If «Count» is less than 1, the empty set is returned. If «Count» exceeds the number of tuples in the set, the original set is returned.
Example
The following code returns the set {France, Germany, Japan}:
Tail({USA, Canada, France, Germany, Japan}, 3)