COGNOiSe.com - The IBM Cognos Community

Hi Guys,

My example data :

	Product1	Product2
ACOMM	5000
BCOMM		3500
CCOMM

I would like to make a OVER() with LAST_VALUE on Product1 whether the next value doesn't exist and FIRST_VALUE on Product2 whether the first element doesn't exist.
And that directly into Report Studio or Framework.

My would like data :

	Product1	Product2
ACOMM	5000	3500
BCOMM	5000	3500
CCOMM	5000	3500

P.S : The void values don't exist into database.

Thanks for your help.