Maybe you already thought of this, but the absolute easiest way would be to create a view that filters on current week and group by Client. This will give you a total that you can view.
Or you could rethink what you are looking at and move this to the Company table that is linked to the Training table. Add a look up from training, that filters on the current week. and add a Roll Up to COUNT(values). This will show you how many trainings a company did that week if any.
yes, the view already exists, however the second part is a bit more difficult in that the company table it’s linked to or rather linked to the training table, isn’t as unique. The company tab is for the Parent company, however each parent company may have multiple trainings, so to accommodate, I created the unique training based on the date of the training and or a subteam.
anywhoo, I’ll see if that will still work, counting that is.