Show only null value in a straight table

[SerSwagster]

Hi everyone. I have a straight table with several dimensions. I want to show the rows having for a specific dimension null values. I can't do this with a separate filter table because null occurrence is not shown in the filter.

For example, I want a table like this (to select all the free agent players):

Player        Role        isNull(Team)

Thanks in advance.

[rubenmarin · Accepted solution]

Hi, you can have a table with Player as dimension, and another calculated dimensionlike:

=Aggr(If(Count(Team)=0,Role),Player,Role)

Uncheking the option to show null values

Or add a table With Player and role as dimensions and an expression like: If(Count(Team)=0,'No Team')