/
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
1A
2A
3A
4B
5B
6C
7C
8C
9C
10C

First create a group using GROUPBY(#RawData!Unit)


Unit
1A
2B
3C

Then use the GROUPROWNUMBER(), and the result shows row numbers within a sorted group series in relation to the GROUPBY() column.


UnitRow_Number
1A1
2A2
3A3
4B1
5B2
6C1
7C2
8C3
9C4
10C5



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
More like this