attendence and filter

Hi,

Want to show no. of people not visited the office not even once with selected month range filter.

I have the week wise data the problem is it should not should not show the emp if he visited even once to the offfice in selected month range but once i select the month it shows emp who is visited in that month eg: if an emp visited the office just for one day in apr then it should not show his name but since other 3 weeks he has not visited the table shows his details. i have created a column that gives 2 values y and n y is when present days is 0 and n is when present day is not 0 and in filter pane it is selected to y

 if i select week no it shows blank which is correct

but if i select the month for this particular emp it should be blank but it gives me the value