filter values of a column in cross table

Hello,

I have a dataset from where i take a variable that has 3 records ('OP2', 'OP3','-' and ' '). I have set this variable as a dimension (groups) in a data cube and placed it in a crosstab on the columns side. How can I filter out value ' ' from this column. I want to show only 'OP2', 'OP3','-'. I cann't filter it out from the dataset or from any dependent variable. All i need is not to show it in the crosstab (to hide this value). Is there any way I can do that?

Thanks,
Taylor

Find more posts tagged with

Comments

thuston

Select the Crosstab and go to the Filter tab in Properties Editor.

Taylor

Thanks

...