2 Replies Latest reply: Jan 29, 2015 11:06 AM by Robyn Talley RSS

    Show dimension with no expression values

      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.