Filter column outside dynamic table range

[JGR]

Hello,

I use a dynamic table which absorbs data from a query regarding the name of sales agents, names and codes of (their) clients, and hours left from a pack. It can be updated to reflect the new amount of hours left, and I can filter by name of salesperson to show only their clients and the hours they still have.

Since I want to make this updating process periodically (once per week), I want to have the column with the updated hours, one with the hours of the last week pasted in values & numbers format, and another one with the substract, so the salesperson knows how many hours their clients have consumed. Like this:

Now, my problem is that I don't know how to filter the copied and substract columns accodring to the salesperson filter:

And when I put a filter on the head of the copied column, the filter by salesperson disappears and it becomes a filter by client code, which I'm not interested in:

Is there a way to correct it? Maybe I can group client codes into a 'filtering group' with the name of the salesperson?

Thanks a lot.