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.