Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

ranking a table or matrix

Hello,   I would like to calculate a ranking score based on the total expenses per project descending (calculated measure) and project number and phase.   ex:   amount (calculated measre)   Pro...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello,

 

I would like to calculate a ranking score based on the total expenses per project descending (calculated measure) and project number and phase.

 

ex:

 

amount (calculated measure)   Project Phase  Rank

 

5000                                           c          1           1

3500                                           A          1          2

3500                                           A           2         3

1500                                          B            1         4

 

What's the best way to calculate the the Ranks?

Thanks in advance for your help

 

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hello,

       

      as per request, I have prepared an Excel file for you but I don't know how to attach the file

      Regards

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        HI Anonymous ,

        You can upload to onedrive or google drive and share link here.
        Notice: do mask on sensitive data before share.

        Regards,

        Xiaoxin Sheng