Concatinate Row Values

[Pramod]

Hi All
I have a doubt can you help me out with this
I have a Column Territory and I have to Concatinate the values of this column
e.g.
Territory
Canada
USA
Japan
Germany

I wanna create a dataitem which concatinate all the values in the column
Territory    Data Item1
Canada      Canada,USA,Japan,Germany
USA          Canada,USA,Japan,Germany
Japan        Canada,USA,Japan,Germany
Germany    Canada,USA,Japan,Germany


can we do this?
Is there any performance factor which will effect the report due to this calculation.

[Naven]

Hi Pramod,

This might help you.

http://www-931.ibm.com/bin/newsletter/tool/landingPage.cgi?lpId=2487&open&cm_mmc=6455-_-n-_-vrm_newsletter-_-11022_143660&cmibm_em=dm::

Regards,
Naveen

[addpremkumar]

Pramod,

There was a function in Framework manager which will concatinate all the row values.

Please search for that..

--Prem