Filter out null categories in crosstable

[Heidi Lehr 2]

This may be something simple but I am having issues getting items that have null values to not show in a crosstable. I have tried filtering several different ways (even if there is a 0 value in the BWPD column) and the field on the vertical axis will not go away (see attached file).

Suggestions

[Aditya Singh 3]

Try [sWD System] is not null

[Heidi Lehr 2]

Tried that and just unselecting (empty) row in a filtering scheme and nothing seems to work. Thx for the response though!

[Fabian Duerr]

Go to the properties of your table and check under DATA what filtering is applied. You can also check addtitional settings of your AXES.

 

If you can't solve this you might want to upload a sample file with this problem here.