LASTCOLUMN |
Description
Returns the last value from a
column.
Syntax
LASTCOLUMN(value,
column1,
column2, ...)
Value_column is
the column that contains the value you want. The column can
be a text, number, or date column.
Column1, column2,... are up to
30 optional columns that define the aggregation context. The
first value is returned for each unique combination
of the group_by columns.
When the result of
LASTCOLUMN is
given as the final value for a new column in a transform worksheet, as
in the example below, each row will get the value of LASTCOLUMN that
corresponds to its particular aggregate values.
If no group_by columns are
provided, the first value in the column is returned.
Example
In
the following we see
how LASTCOLUMN works with a numeric column and a single aggregation
column. The calculated value is entered in each row.
Sample
Data
Unit
Sales
|
Store
|
=LASTCOLUMN(Unit
Sales,Store) |
NUMBER
|
TEXT
|
NUMBER
|
157
|
West |
157
|
127
|
Central
|
|
|
Central
|
|
353
|
North
|
353
|
104
|
East
|
105
|
105
|
East
|
105
|
|
 User Comments |
 |
|
| Click Here to be the first to post a comment. |
Support Home
| 
Glossary | 
Contact Us 
