Create a trend field in a project about a tournament

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


This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.