Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a straight table with two columns: A and B with the following values.
I want to show only those values of column A which have only NULL values of Column B.
For e.g., for column A =60 and 63, Column B is NULL and NON-NULL. So, in this case I want to show all values of Column A except 60 and 63.
Thanks.
Hello Simran,
you can use filter on the column A '=isnull(B)' as radoresky mentioned in one of his posts .
BR,
Maria
Hi Maria,
I want to show only those values in the table which are only NULL.
I don't want to show the NON NULL values.
Thanks.
try this
May be a calculated Dimension:
If(Len(Trim([YourField])) = 0, 'Null', Null())
Hi,
Add Calculation Dimension for Column B like below.
=if(isnull(B),B)