Counting goals in a championship

[juan.manaure]

Hello!
I am a beginner and to practice I made an app to record information about soccer matches for my group of friends.

I create the matches, input the scores, and record who scored the goals and who made the assists.

Now I am trying to add the matches to a championship. My question is about this part. I can put the matches into a championship, and I can make them appear in the repeater group, but I am having trouble counting the goals only for the championship.

Each match has a list of players who scored the goals, for example: [Joao, Marcos, Paulo, Paulo]. In this example, Paulo is repeated because he scored 2 goals.

I would like to make a repeater group to show the goals and assists only for the championship. I can get the list of names but I can’t do the counting.

I don’t know if my question is clear. Can anyone help me?
Thank you

[rakshitkumar90]

You can use constraints while searching for data under a certain championship

[juan.manaure]

I managed to filter the athletes who scored in the championship games and I did the counting. That part worked. Now I’m having a problem that I don’t know how to sort. It doesn’t have any option.