Forum Discussion

Malsha's avatar
Malsha
Helper I
3 years ago
Solved

Use two filters

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?


Need Help
  • AlanP514's avatar
    AlanP514
    3 years ago

    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 

3 Replies

  • AlanP514's avatar
    AlanP514
    Post Patron
    3 years ago

    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 

    • AlanP514's avatar
      AlanP514
      Post Patron
      3 years ago

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