Forum Discussion

cham's avatar
cham
Icon for Post Patron rankPost 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
Icon for Super User rankSuper 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
Icon for Post Patron rankPost Patron
6 years ago

Hi jdbuchanan71 

 

Did you find any way to solve this? Can you please help me with this?

  • jdbuchanan71's avatar
    jdbuchanan71
    Icon for Super User rankSuper User
    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.

  • cham's avatar
    cham
    Icon for Post Patron rankPost Patron
    6 years ago

    Hi jdbuchanan71 

     

    Thank you so much for your help. Appreciate it :)