ranking a table or matrix

[Anonymous]

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)   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]

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

[v-shex-msft]

Hi @Anonymous ,

Can you please share some sample data for test?

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

[Anonymous]

Hello,

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

Regards

[v-shex-msft]

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

[Anonymous]

Thanks for the information on One Drive and Google Drive.  I will prepare a sample data set and save it on probably one drive then I will send you the link.

Thanks in advance for your assistance.

Regards,