Use two filters

[Malsha]

Hi Everyone,
Good day to all!

I'm creating a report which has employees data and report has a date filter which takes the employees' termination date.

so the report only gives employees data who has termination data. which means data about past employees. 
In the report there's another filter to get current employees and past employees (in this filter option also now only displays past emploees option since the report has termination date filter). but I can't get current employees data since report filters by termination date. I need to show the both current emploees and past employees in the report.

Can anyone help me to solve this problem?

[Malsha]

Hi, Thank you forthe solution.

[AlanP514]

Hai, if you find this is as a solution , kkidnly accept it as an a solution

[AlanP514 · Accepted solution]

Hai @Malsha 

For your requirment you need to create one calendar  table based on the date columns which is avaialble in your table
and you need to create two relationships one is active and anothe rone is inactive 

in this way only yo can see both employees