Problem is, it's showing the people who worked there in 2018, which is great, but it shows their revenue and gross margin for the whole year. I want to show this only for the time they worked there. I could create a different table containing all the customers, but in the financial transactions table employee costs like Carlease etc. on which gross margin is calculated are not linked to a customer.
Is there a way to filter the financial table on months which the employee registered hours at that customer?