I want to show in the table the number of holidays per person whatever else is selected, but just the persons in the selected departments. So for example if department1 is selected I want miller and smith with two holidays.
Has someone an idear how I can solve this problem?
Are you sure that your Holiday table should even be connected to your Work table? The reason only one of the holidays counts up is because nobody worked on 01.01.2014. Therefore when you select something in the Work table, it will definitely filter out that date and depending on your selection might also filter out 06.01.2014.