Hi all,
I’ve a table with all teams and other table with the standings of the matches.
Now I want create a field with the trend of the tournament, for example a field with last 5 positions?
Someone know a formulas to do this?

Team Table

In this case I want in Trend field about Team A this values:1,3,1

Tournament Table

Thanks