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.