Hi, I need to compute occupancy levels for some regions however, in order to do this I should first figure out the exact number of hours worked by employees. Sometimes some employees are on vacation so I should filter out those employees when they were on vacation. I have a vacation table that shows C To Date Fromatted and C From Date Formatted that shows the beginning and end date of the vacation for users. I need to create some way to filter them out, I tried parameters and it worked but the problem with it is that it doesn't work on weeks and would rather create an sp vacation field and filter them out.
I attached an example of the workbook, the parameter is used but would rather work around without it.