COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: cognosun on 01 Dec 2014 10:51:43 AM

Title: Crosstab - 2 values in one intersection cell
Post by: cognosun on 01 Dec 2014 10:51:43 AM
     E   H
a 100 33
b 299 33
c 444  22
   321 
d 211  45

Say this is my Crosstab report, is there any way I can display 444,321 measure values (@intersection of E and c) ?
Strange question, but wanna know.

Many thanks in Advance
Title: Re: Crosstab - 2 values in one intersection cell
Post by: MFGF on 01 Dec 2014 11:00:45 AM
Hi,

That really doesn't appear to make any sense. What you see in an intersection is the measure value that corresponds to the row and column value at that intersection. How can you have two different values for a measure in this situation? Can you explain?

MF.
Title: Re: Crosstab - 2 values in one intersection cell
Post by: qvixote on 01 Dec 2014 12:08:44 PM
Maybe if you explain the origin of your need we could help you to find another way to show what you want.
Title: Re: Crosstab - 2 values in one intersection cell
Post by: ravimahazan84 on 02 Dec 2014 08:05:28 AM
you can use the repeater and it will solve your problem.in case you need further detail send me an email  to Whizz whizz whizz. My email address flew away never to be seen on the forum pages again. I promise to try hard not to post it up again in future .i will revert you back on that.
Title: Re: Crosstab - 2 values in one intersection cell
Post by: Lynn on 02 Dec 2014 08:18:46 AM
Quote from: ravimahazan84 on 02 Dec 2014 08:05:28 AM
you can use the repeater and it will solve your problem.in case you need further detail send me an email  to xxxx@xxxxxxx.xxx.i will revert you back on that.

Please review point 7 in the Forum Etiquette post:
http://www.cognoise.com/index.php/topic,24030.0.html

You should not be including your email address in posts. Also, why wouldn't you share the information so that others may benefit?