Print Page - merge two entries

Title: merge two entries
Post by: mansoor2811 on 09 Dec 2007 12:45:11 AM

Hi all,

How can i merge two different rows in to one.

Ex: i have two rows with

1. germany
2. France

I want to merge them with there values and make one

Europe.

is it possible to do can u please help me out...

Thanks in advance
mansoor

Title: Re: merge two entries
Post by: MFGF on 10 Dec 2007 03:31:03 AM

Hi,

How about a query calculation:

if ([Country] in ('Germany','France')) then ('Europe') else ([Country])

Regards,

MF.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: mansoor2811 on 09 Dec 2007 12:45:11 AM