first row of the group 2

sssdexter · Oct 13, 2003

Hi,

I have a grouping in DW, i like to find out every first row of the group break, how can i achieve it?

Thanks a lot.

tabhijit · Oct 13, 2003

Hi,

You can use FindGroupChange to find first row of group.

Thanks,
Abhijit.

sayonara · Oct 13, 2003

Please try with computed expression

IF( cumulativeSum( 1 for group 1 ) = 1,1,0)

If this returns 1 then it is a first row of the group.

Regards

sssdexter · Oct 13, 2003

Hi,

Thanks a lot ...

one is a script in power script, one is a DW scripts. Very helpfull.