I think you can use the technique described here to get the rank
amongst the other teams that year, without filtering those teams out:
Basically, LOOKUP(ATTR(Team ID),0) is placed on the Filter shelf.
Then [Team ID] needs to be placed on the detail shelf,
and the Table Calculation settings need to set as shown below.
Please see the workbook v10.5 attached in the Forum Thread.
284141rank.twbx 10.2 MB