Forum Discussion

cham's avatar
cham
Post Patron
6 years ago
Solved

TOP N not working

Hi, I want to get the TOP 5 driver numbers according to the amount. I tried it as below but its not working. Can anyone help me to do this?       
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • jdbuchanan71's avatar
    jdbuchanan71
    6 years ago

    Hello cham 

    I believe I did find a way to solve this.  I had to add a drivers table to use as a anchor for the rankings.

    The udpated file is attached.

jdbuchanan71's avatar
jdbuchanan71
Super User
6 years ago

cham 

There are 25 drivers in Canada all with N = 100.  Which 20 of those do you want?

cham's avatar
cham
Post Patron
6 years ago

Hi jdbuchanan71 

 

I have added a resposes field that now you can filter it. Please check the updated file.