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

Display only first Crosstab Node Value

Started by moutaye, 17 Jun 2014 05:17:06 AM

Previous topic - Next topic

moutaye

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

nblank

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

moutaye

Thanks for the answer

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