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

How to suppress zeros on crosstab?

Started by ReportWriter, 10 Aug 2007 02:40:16 AM

Previous topic - Next topic

ReportWriter

If I have a crosstab where product types are on the rows and three types of different measures on the columns, how can I suppress zeros? I want to remove the rows and columns, which have only zero values. That should work also for drill down.

Does it work also with slicers?


Report looks like this:
           
                             Continent
                   |Sales1|Sales2|Margin|
-----------------------------------------------------------
Prod type1|
Prod type2|
Prod type3|
Prod type4|

Suraj

replace the measure with a data item that has a condition that makes it null when the value is 0.
crosstab automatically surpresses null values.