I have a a worksheet filter by "team" in column A. Column C is Goals Scored,
and I have applied a "Top 10%" Filter.

This is giving results in the Top 10% of the entire column, whereas I want
the Top 10% of just the team I have filtered in A.

Any ideas ?