Show dimension with no expression values

[#1]

Hi -

I have a straight table that simply is calculating how many sales per employee.  I want to only show employees who haven't had a sale.  There is a null/missing symbol in the Transaction ID field for those who didn't have a sale. 

I've tried unchecking suppress the missing values and checking show all values.  That doesn't work because my employee field includes some who are terminated.  I only want to show active employee with no sales.

Any help would be appreciated.  I have attached a qvw with test data.

Thanks,

Robyn

[rubenmarin · Accepted solution]

Hi Robyn, you can add a calculated dimension like:

=Aggr(If(Count([Trans ID])=0, EMPLOYEE), EMPLOYEE)

The table in your sample file is a 'Table Box', not a 'Straight Table'. In table box you can't use calculated dimensions.

If you want to remove inactive employees you need a field that identifies each employee as active or inactive.

[#3]

Thanks Ruben -  This worked perfectly.  I did apply it to a straight table and not the table box.