Add a field from second record (of the same person) to a report?

It would still work that way. I imagine your 'most recent' team is their current, where as the 2nd most recent (1st inactive) is right before it. You can achieve it by just filtering the most recent record where Status = Inactive so you ignore the most recent active assignment. If you need the most recent (2) teams, so you'd have your current team, the prior team, the prior team you can still more or less leverage the same technique by summarizing the RID of the most recent inactive team, bringing that back down as a lookup, the summarizing the RID of the most recent inactive team where it's not equal to the actual most recent and on and on.