I'm creating a QV chart to show all consultants that have submitted time sheets for a given week.
I have a table box (called "submitted") that has a list of consultant names. I then have a list box, which allows you to select a particular week-ending date. This will (obviously) filter the consultant names in the "submitted" table by consultants that have submitted a timesheet for that particular week-ending date.
Is there a way to create another table, which shows which consultants did NOT submit a timesheet for the week-ending date that was selected? In other words, a table that shows which consultants dropped off the "submitted" table, when I selected the week-ending date?
Gysbert, wouldn't that just give me a count, not the actual consultant names?
I've attached my QV. Since I'm terrible at explaining (guilty!) - you can see the "Submitted" table, and on the left, the "Week-Ending" list box. I need an additional table, which shows me the consultant names which fall off the "Submitted" table when you select a Week-Ending date.
Could you create an excel file with some lists that show who should be in which listed based on some selections? I don't know what the correct results should be. Having some examples to match with would help.