/
GROUPROWNUMBER
GROUPROWNUMBER
Syntax
GROUPROWNUMBER()
Description
Returns with a created row number for each record in a group series.
This is a group series function.
Example
Given the following data:
Unit | |
---|---|
1 | A |
2 | A |
3 | A |
4 | B |
5 | B |
6 | C |
7 | C |
8 | C |
9 | C |
10 | C |
First create a group using GROUPBY(#RawData!Unit)
Unit | |
---|---|
1 | A |
2 | B |
3 | C |
Then use the GROUPROWNUMBER(), and the result shows row numbers within a sorted group series in relation to the GROUPBY() column.
Unit | Row_Number | |
---|---|---|
1 | A | 1 |
2 | A | 2 |
3 | A | 3 |
4 | B | 1 |
5 | B | 2 |
6 | C | 1 |
7 | C | 2 |
8 | C | 3 |
9 | C | 4 |
10 | C | 5 |
, multiple selections available,
Related content
GROUPROWNUMBER
GROUPROWNUMBER
More like this
GROUPROWNUMBER
GROUPROWNUMBER
More like this
GROUPUNIQUES
GROUPUNIQUES
More like this
GROUPUNIQUES
GROUPUNIQUES
More like this
GROUPUNIQUES
GROUPUNIQUES
More like this
GROUPBY
GROUPBY
More like this