Hey guys - I posted this question before, but it had no responses in hours, and I'm on a strict deadline. Hoping you guys can help.
I've attached my QV if you wanna take a look.... here's my issue:
My QV will be used to track timesheets. It will show which consultants have submitted timesheets, and if they were late or on time. It should also show if the consultant never submitted the timesheet at all.
I have a pivot table called "Submitted", a pivot tavble called "Late", and one called "Not Late". These are driven off of a list box called "Week-Ending", which is the day the pay period ends.
The user should be able to click a specific "Week-Ending" date, and then see who submitted timesheets and who didn't, and which of them were late or on time.
I have everything worked out, except the "not submitted" table...
The "Submitted" table is just basically the first and last name of the consultant... if you dont actually filter the data by picking a "Week-Ending" day, it's a list of all consultants... is there a way to make a table, and have it compare the list of consultant first and last names against the "filtered" version of itself, after someone selects a "Week-Ending" day?
In short, I need to know which consultants drop off the "submitted" table when I select a Week-Ending date.