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|
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.