How to apply filter row condition to find first occurrence of data?

[Saifabbs]

I want to find the first occurrence of data and use it to apply the row filter condition.

I have a table with a user ID, team, cost, and balance.  I want to filter rows to only show where first appear in the team column.

I have tried using lookup to get the row number of the particular row but it doesn't work.

The above is without applying any row filters.  Since all the rows have the same pending sum I want to show only the first occurrence of it.