Sorting sports table

Hello,

I’m trying to create a table for a football (soccer) league in a repeating group and I want to sort it with two data fields. The first and most important one is points. The team with the highest points will show up on the top of the table. But if two teams have the same points, the team with the highest goal difference should be showed first.

If you look at the picture below:
Skärmavbild 2023-11-16 kl. 13.57.56

The numbers mean (from the left): Games played, wins, draws, losses, goals scored, goals conceded, goal difference, and points. So in the example above, the team on third place should actually be on second place, since they have a “higher” goal difference. How do I do that?

Set a secondary sort field on RG and set it the goal differential field. Descending = yes

Thank you. The problem is that I don’t understand how I set a secondary sort field on the RG?

Thanks!

1 Like