Remove row when measure cell is blank in crosstab

[plunavat]

Hello,

how do we remove the entire row when the cell in measures is null or blank

i have checked "Remove Line when Blank" and "Blank when null", but not giving desired result

 

Thanks in Advance

Regards,

Pranav C Lunavat

[nthapa]

Why dont you add filter? right click on the column which could have those values and click on add filter, specify the filtering criteria.

HTH