Print Page - Row number for group

Title: Row number for group
Post by: stancho on 14 Jan 2014 11:32:56 AM

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

Title: Re: Row number for group
Post by: Francis aka khayman on 15 Jan 2014 01:13:57 AM

try

rowNum = running-count(distinct [colA])

List:

[rowNum] [colA] [colB]

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: stancho on 14 Jan 2014 11:32:56 AM