You can do this already by selecting "Clubs" on the left menu of the public pages. And then from clubs you can select "Teams" on the left menu. Subsequent stats are for that team only.

I will move this to the questions section.

Could I re-visit this one please!? Although I have no problems with the work around as described above, in reality I get complaints from users saying that they can't get a breakdown by club or team. Would it be possible to consider these dropdowns on the public site to improve the user experience?

Please raise this as a new suggestion in the suggestion area. Note that a common way to solve this is to give people level 1 access to the admin panel where they can get access to all of the various filters.