If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

merge two entries

Started by mansoor2811, 09 Dec 2007 12:45:11 AM

Previous topic - Next topic

mansoor2811

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


MFGF

Hi,

How about a query calculation:

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

Regards,

MF.
Meep!