Last

Returns the last "n" number of elements derived from the given list based on the given number of items to return.

Syntax & Usage

Tail([List], number of elements)
  • Create a list from which you want to derive the subset of elements.
  • Connect the "Last" block to the list and enter a fixed value or parameter from the Insert Arguments window, to determine the number of elements to return.
  • Select "Exclude from Result Set" if you want to remove the last "n" elements from the list (as opposed to creating a list from them).

Example

Here the first 20 elements are returned from the Product hierarchy:

{Tail({AllMembers([products].[Product])},20)}