Can I create a points ranking with my App?

[neardj]

Hi,
I need your help.

Do you think it is possible to create a points ranking through APPSheet?

I have two tables in my app.
My first table is called “T_FORMAZIONI_DB” and contains the columns:

• IDFORMAZIONEDB
• ID_CICLISTA
• CODICE_AGGREGATIVO

this table shows the cyclists that each coach has selected for a specific race.

The second table is called “T_RISULTATI” and contains these columns:

• IDPUNTI
• ID_CICLISTA
• IDCORSA
• PUNTI
• CODICE_AGGREGATIVO

How can I create a UX view that summarizes the points made by a team present in the results table only if ID_CICLISTA and CODICE_AGGREGATIVO of that row are present in the “T_FORMAZIONI_DB” table?
It’s possible?
Thank you
Luigi