Issue with display while using crosstab space

[Cognosuser2019]

Hi All,

I am facing an issue with the crosstab. Need your assistance with it.

Please see attached sample report.
I have to display all priority and reason codes irrespective of whether data is there or not. For which I have used left outer join. So I am getting few records with null priority and reason codes. I need to hide this from the display.

I used a variable and tried to hide the null but this is causing the cells to shift to the left and causing alignment issues. Since I am using crosstab space which spans across all the codes I am unable to hide the crosstab space.

Hope the question is clear. Any thoughts and ideas would be of great help.

[BigChris]

You haven't said what source your data is coming from, but assuming it's relational you presumably need filters for

Code Select Expand

[Priority] is not missing
and

Code Select Expand

[Reason Code] is not missing

[Cognosuser2019]

Thank you BigChris for the response. When I do that it is filtering out the records that I need. I was able to achieve it using union. Appreciate your help.