Row number for group

[stancho]

Hi all,

I have one list report which has several columns. I'm did GROUP on the first column,
unlocked the first cell and put Row Number in it.
The row number is showing the number for every single line. One group from the first column  can contain several rows so the first column is looking something like this:

[1 - colA] [colB]
               [colB]

[3 - colA] [colB] (the next row number that is showing is 3 because the first group contains 2 rows).

How can I show the number of the rows but according to the grouping of the first column.
so to show:

[1 - colA] [colB]
               [colB]

[2 - colA] [colB]

Thanks

[Francis aka khayman]

try

rowNum = running-count(distinct [colA])

List:


[rowNum] [colA] [colB]