Urgent Help requires Slicer to filter data from two datasets

I have two datasets, one with Employee hours worked in different departments and the other with Sales of the store in these departments. The issue is that the hours dataset

has a few different departments as compared to the sales (Credit Card, Gift Card and Support). I do have Operational departments in both datasets as well. I need to use a slicer to get the operational deparments selected from both datasets which will give me sales dollars from sales dataset and the hours worked in those departments from the work force departments.

But I have issues in doing so:
1- The departments in Sales and Hours datasets are not matched 1-1
2- For each Sales Department, I do have Sales from 3 operational departments; i.e. Cash, Credit card, Gift Card. A customer can pay in either of these 3 ways.

3- In the Hours Dataset, I do have hours against only the Hours departments and employees selling Gift Cards and Credit Card have separate hours.

What I want is if from the Slicer,  I will select Cash, then I will get all the sales against Cash from each department and from Work force hours data I will get all the departments worked hours.
When I select Credit Card slicer then I will get all the Sales against these operational departments and from the hours I will get worked hours against Credit Card. Same with the Gift Card.
Support , I will get hours when I select support and no sales value.

I would really appreciate it if I will get help do this.