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

Sectioning - Splitting

Started by cognosun, 05 Dec 2012 10:13:12 AM

Previous topic - Next topic

cognosun

We have 2 measure columns ( which are amounts) in the report say n1,n2

We sectioned it  on there currency, say if n1 amount's currency is USD and n2 amount's  currency is USD, sectioning is happening as expected on USD.

We run into a requirement where n1 amount is linked to one currency ( say Yuan), and n2 amount is linked to another currency ( say EURO).

At this point sectioning should get split, i.e. one with Yuan ( here n2 values may appear null or zero) and one with EURO ( here n1 values may appear null or zero).

GURUS...Is it possible in Cognos.




cognosun

Is there way to achieve this....