FIRSTCOLUMN |
Description
Returns the first value from a
column.
Syntax
FIRSTCOLUMN(value,
column1,
column2, ...)
Value is
the column that contains the value you want. The column can be a
number, date, or text 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 FIRSTCOLUMN 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 FIRSTCOLUMN 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 FIRSTCOLUMN works with a numeric column and a single aggregation
column. The calculated value is entered in each row.
Sample
Data
Unit
Sales
|
Store
|
=FIRSTCOLUMN(Unit
Sales,Store) |
NUMBER
|
TEXT
|
NUMBER
|
157
|
West |
157
|
127
|
Central
|
127
|
|
Central
|
127
|
353
|
North
|
353
|
104
|
East
|
104
|
105
|
East
|
104
|
|
 User Comments |
 |
|
| Click Here to be the first to post a comment. |
Support Home
| 
Glossary | 
Contact Us 
