Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Top 25 Customers

I have one table for partner which has Partner Name, another table which contains region information, Country and Area. One transaction table which has revenue by partner by customer. I want to show ...
  • v-piga-msft's avatar
    8 years ago

    Hi Anonymous,

     

    It seems that you have three tables, have you created the relationship among the tables?

     

    As the Zubair_Muhammad mentioned, you could use RANKX function. Here is a blog about how to use this function you could refer to.

     

    If you still need help, please share some data sample which could reproduce your scenario and your desired output, so that we can help further investigate on it?

     

    Best Regards,

    Cherry