Forum Discussion

fansari's avatar
fansari
New Member
2 years ago
Solved

How to Create Dynamic Top 10 Columns in Matrix

Hello,   Essentially, my data has two country columns: producing country and policy country. Every cell in the data has a non-blank pair of producing country and policy country. In addition, every ...
  • Daniel29195's avatar
    2 years ago

    fansari 

    you need to add the rank as measure in the matrix, and you can then sort base on it . 

     

    you can do it like this https://www.youtube.com/watch?v=1bp_e-ik7aA  

    i think it could be done for you, since you have limited nb of columns ( = 10 ) , so you can hide them using this technique . 

     

     

     

    If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. I would appreciate hitting that kudos button ๐Ÿ‘๐Ÿค