Print Page - Display only first Crosstab Node Value

Title: Display only first Crosstab Node Value
Post by: moutaye on 17 Jun 2014 05:17:06 AM

Hi Cognos Experts

I have a requirement to display only the first value of my crosstab nodes.

E.g. instead of having this..

a b c
d
a e
f
g

.. I want to display this:

a b c
d
e
f
g

Any idea how to do this gentlemen?

PS: I'm using Report Studio 8.x

Thanks in advance for your help

Title: Re: Display only first Crosstab Node Value
Post by: nblank on 09 Jul 2014 02:38:33 AM

Do you work with fact and dimension? If so "a" is the parent level in your dimension and "b" and "e" are in the child level of your dimension. c,d,f,g are measures in the fact. When you dragg the parent en child level in the crosstab the parent level wil group automatic

Title: Re: Display only first Crosstab Node Value
Post by: moutaye on 10 Jul 2014 05:17:51 AM

Thanks for the answer

I got confused by crosstabs but i just dragged my measurements in the crosstab nodes insteadof columns and it worked

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: moutaye on 17 Jun 2014 05:17:06 AM