AnsweredAssumed Answered

League Table

Question asked by crmorris2 on Oct 23, 2017
Latest reply on Oct 25, 2017 by philmodjunk

Hi everyone, hope you can help, am a bit confused on this one.

 

I am trying to create a 'league table' where i have something similar to the below example....

 

1. UK            39

2. Spain        37

3. Ireland      20

4. Greece     18

5. Germany  10

 

So I have different data from 3 different tables. 'Joined course', 'country' and 'voucher code'.

 

They are all related so I really just need a table that only shows one instance of each country (instead of a long list) and then counts how many vouchers that country has used and then sorts the table by points.

 

I am an intermediate user but just can't work out the best way to do this.

 

Any help would be greatly appreciated

 

Thank you in advance

Outcomes