Except function with a filter - unlogged employees

Ashish_Mathur Thanks for your steps. I have tried but not sure why it dint work the way I wanted.

Thanks every one for giving me different options, but still haven't got the desired result.

v-xicai 

Amy, here is the scenario

Table 1 contains the log data of all the employees (maintains history) (fields - employee name, logdate, many other columns)

Table 2 contains the total employee name list (unique) with start and end date of employement.

Both the tables are unrelated.

Date table exists with join to logdate of Table 1.

The report uses a slicer based on Logdate to select a date or range.

Then I need the report to compare Table 1 and Table 2, to get the list of missing employees from Table 2 (if any), so that I can follow up with the missing employees as to why they dint log their time.

Looks simple theoretically, but I am unable to achieve in practical.

Let me know, if I am not clear in explaning the requirement.

Thanks in advance!

Dave