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?