Skip to Content
Former Member
Oct 18, 2013 at 09:02 AM

How to filter rows in Webi Crosstab?



I am working on XI 3.1 SP5 / Java 6 / IE 8.

I have crosstab in Webi in below format with empty Left header:

With data, it looks like below:

the [measure 2] is returning zeros and I wish to filter the row; however, it is not working.

I tried to use a report filter like [measure 2] <> 0 at report level; however, it is hiding the whole block.

There is an option for Crosstab properties: "Show rows with empty measure values".

I searched on internet and found that the ASCII value for NULL is '0' so i tried to replace zero values with NULL by using below logic:

=IF ([measure 2] = 0 Then Char(0) Else [measure 2] But I was unable to utilize the aforementioned option as it is not returning NULL but just a space.

Even =IsNull(Char(0)) returns 0 i.e. Char(0) is not returning NULL.

Can anyone please help me in hiding the second row with 0s?