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.
Is there way to achieve this....