Given a sort expression list, this Ordered Analytical function derives a new column indicating the last value over an ordered “window” of values. When one or more Partition Columns are specified, the last values are determined separately over the rows in each partition.
The standard Rows options that define a “window” of values are available with the Last Value functions, as described in Windowed Aggregate (Generic). They may be viewed or changed on the Properties panel, as seen below. An additional option, Ignore Null Values, is provided for the Last Value functions. When this option is in effect, the last non-null value in the requested “window” is returned by the function. By default, null values are not ignored.
When dragging a Last Value function into a variable, the following tree element is created.
Sort expressions can be built up in the Sort Expressions folder, Partition Columns can be built up in that folder. Double-click on Last Value, or highlight it and click Properties to set the properties for this function.