Suppress when val is Null

[Sivapriya_d]

Hi All,

I am using one table in my dashboard and selected Suppress when value is null option. Its working fine. But I just wanted showcase one column in the table with Values even the other columns having "Null" values.

For Example my table is like this

If I give suppress when value is null based on ID, the last row wont be available .What  i need to show is for the over all table view i don't need Null ID rows but when i made selection over Name filter the table should show Name column like below

Is it possible?.

Thanks,

Siva

[sibin_jacob · Accepted solution]

Try this one for your ID dimension

if(GetSelectedCount(Name)=1 and isnull(ID),'',ID)

Check Supress when value is null

[MarioCenteno]

Try

=Alt(SUM(id), 0)

[Sivapriya_d]

Thanks its working .But i am not getting the first column

Cheers.

[MarioCenteno]

Try

=Aggr(Alt([name],0),ID)

Or

Alt(id, 0)

[Sivapriya_d]

Thanks Sibin.Its Working

Cheers,

Siva