I have three tables
The first table contains projects number and project-specific information
The second table contains a list of time entries with a project number field along with employee number and employee-related entry
The third table contains a list of milestones again with a project number field and information related to the milestone.
Both the second and third tables and related to the first table in a one to many single relations with the project number of the first table.
How can I transfer the filter using a field from the second table to the third table?
I would like to have a page where I could dynamically filter the project information, sum the hours and show the related milestones status bases on a slicer using an employee-related field in the second table.
Thanks
