conditionnal style - not show blank line

[philelmousse]

Hello,

My goal is to hide blank line in my crosstab.

My crosstab is built like this :

Dimension1 Dimension2 Measure1 Measure2 Measure3 Measure4

I have many dimension2 members by Dimension1 member.
If a member of dimension2 doesnt have any value in the measure I dont want display the member of the dimension2.

I made something but it doesnt work because if there is only one member of dimension2 with null measure for only one dimension1 it will hide the line also for the other members of dimension1

[bi4u2]

Phil, I usually achieve this by using suppression. Select the Crosstab (you may have to go to select ancestor to get the crosstab properties). Then go to Data/Suppression/Suppress Rows. You can choose whether to select 0 values or missing values under suppression options.