Hello,
I have a table containing information about clients: surname, first name, end date, etc., as well as the number of hours sold. In another table, I have the tasks for each customer with the number of hours used.
I've created an interface that summarises the job information by customer. At the moment, I need to filter by customer to display all the tasks, but I also want to see the number of hours sold directly in this interface.
However, to obtain this information, I need to apply two filters:
Filter 1 on the Tasks table to select the customer. Filter 2 on the Customers table to retrieve the hours sold. Is there a solution to avoid having to filter twice?