Forum Discussion

JH's avatar
JH
Frequent Visitor
8 years ago

Top N Ranking in Concentration Chart

Hello,

 

I'm trying to create a concentration chart, ranking our customers according to their revenue. I should look somehow like this: 

I need to use some sort of formula, such as: TOPN or RANKX to always have automatically the top 5 vendors pictured. I further need to filter it by Country. 

 

However, I can't get my head around the TOPN Formula as I keep making syntax mistakes.

 

The data used is the following:

Vendor_name in the vendor table

Total_revenue in the revenue table 

(both tables are correctly joined)

 

What I need is that the vendor_name ranks themselves according to the Total_revenue collumn. 

 

Can smn help me out? 

 

(No, I can't just use the TOP N Filter :) )

 

 

Thank you!  

 

 

 

 

Need Help

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    8 years ago

    Hi JH,

     

    Could you give more details about your tables and measures you are using? In addtion, you said "vendor_name ranks themselves according to the Total_revenue collumn", vendor_name is a table, right? So which column do you want to rank by column [Total_revenue]? Are there some other columns should be used as category column to be group by? Please clarify more details about your expected requirement.

     

    Regards,

    Jimmy Tao

    • JH's avatar
      JH
      Frequent Visitor
      8 years ago

      Hi Jimmy,

       

      Thanks for your reply and sorry for my late answer! 

       

      I want the different vendors name (vendor being the table, and name the measure) ranked by total revenue (Internal Revenue being the Table and Total internal revenue the measure). I do not need any extra category for now :)