Repeating group list sorted and group by data field

I am trying to replicate a list of fixtures similar to the below image.

I currently have a list of fixtures in a data type with each entry having a gameweek number. The date that shows in the screenshot will relate to the gameweek of the fixture.

My question is, can i create a repeating group that lists all fixtures grouped and sorted by gameweeks?

gameweek 1
fixture 1
fixture 2
fixture 3
fixture 4

gameweek 2
fixture 5
fixture 6

Finally cracks this one.

I created a repeating group with the data source grouping and sorting the fixtures by gameweek. The dynamic text in this repeating group displays the grouping number (Gameweek 1,2,3…).
I then created another repeating group inside the other repeating group with the data source set to the same list of fixtures but not grouped, instead filtered by the parent group’s Grouping gameweek. This produces a list of fixtures with the gameweek in the current cell of the first repeating group.
Here are my screenshots


5 Likes