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