Forum Discussion
Import Hours/Export Hours Help
The following sample file can be downloaded. It appears as follows:
Essentially, there is the EmOrg (Employee Office) and PrOrg (Project Office). When the right three digits of each match it means the Employee has charged time to a Project that belongs to their office. When the Employee's Office does not match then that is considered an Export of Hours. When the Project's office does not match the Employee's Office then that is considered an Import of hours. What I would like to try to create is a visual that has two matrix's - one for export of hours and one for import of hours. There would be one slicer for the office. Thus, if the user chooses Seattle then it would show Seattle employee's export of hours and the other matrix would show Seattle project's who imported hours for non Seattle employee's.