Forum Discussion
Import Hours/Export Hours Help
Hi danielpaduck
Here are some of the suggestions I gave:
Create Relationships:
Ensure that there are relationships established between your ‘Labor Detail’ table and both the ‘Employee’ and ‘Project’ tables. The relationships should be based on the office or region code.
Adjust Relationship Settings:
In the relationship settings, change the ‘Cross filter direction’ to ‘Both’. This allows the filter to apply in both directions.
Create a Slicer:
Use a slicer visual in your report and tie it to the region code column in the ‘Labor Detail’ table. This slicer will now control both the employee org and project org.
If you're still having problems, provide some dummy data and the desired outcome. It is best presented in the form of a table.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I will see if I can provide some dummy data. Essentially, the Labor Detail table has two Office Columns. One column identifying the employee's office and one column identifying the project's office. Also, there is just one office dimension. The business rule is that when an employee's office does not match the project's office that is considered an export of hours. Likewise, when a project's office does not match an employee's office that is considered an import of hours. If I just have one office dimension, then how can I create a report that has two matrixes. One matrix will show export hours for an office (Waterloo employees) while the other matrix shows the import hours for any Waterloo project?