Hiding empty columns in crosstab report

[hem852]

Hi

I have a crosstab report.

Accross the top I have a dimension of 'Legal Type' and under that a dimension named 'Game Name'. (Each Game Name fits into a Legal Type).

The 'Game Names' Dimension creates a number of columns relating to different Game Names under the individual Legal Types.

The problem is under legal types I get a column for every game name displayed, regardless of whether it fits into that legal type. The actual data values only show under the correct legal type. If the Game Name does not fit into a Legal type I get the column header but no data.

Is there a way to ensure that the Game Names only display under their appropriate Legal Types or failing that is there a way to hide Game Names with Empty columns?

TIA

John

[CognosPaul]

Instead of pulling the level directly into the crosstab, try something like this:

Code Select Expand

filter([Cube].[Dimension].[Hierarchy].[Level],[Cube].[Measures].[Measure]>0)

[david.stachon]

...or better yet, if you're on 8.4 use zero suppress.

[hem852]

Thanks Gents,

Sadly David we are still on 8.2 :(

Paul, this worked great thank you.

[ramya]

Hi!..
   I have crosstab report.I have taken "Routes" at columns ,"vehicles" at Rows and students count who are belongs to specific vehicle and route as Summarized fields..I need not to display intersection cells having data as "0"..I want to supress that cells having value zeros..
    Thanks in Advance!....

[ramya]

anyone plz give me reply