ranking a table or matrix

Question

Hello,&nbsp;I would like to calculate a ranking score based on the total expenses per project descending (calculated measure) and project number and phase.&nbsp;ex:&nbsp;amount (calculated measre)&nbsp; &nbsp;Project Phase&nbsp; Rank&nbsp;5000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;c&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;13500&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 23500&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;31500&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4&nbsp;What's the best way to calculate the the Ranks?Thanks in advance for your help&nbsp;

anonymous · Answer

Hello,&nbsp;I would like to calculate a ranking score based on the total expenses per project descending (calculated measure) and project number and phase.&nbsp;ex:&nbsp;amount (calculated measure)&nbsp; &nbsp;Project Phase&nbsp; Rank&nbsp;5000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;c&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;13500&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 23500&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;31500&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4&nbsp;What's the best way to calculate the the Ranks?Thanks in advance for your help&nbsp;

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,
Can you please share some sample data for test?
How to Get Your Question Answered Quickly 
Regards,
Xiaoxin Sheng

anonymous · Answer

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

anonymous · Answer

HI&nbsp;Anonymous&nbsp;,
You can upload to onedrive or google drive and share link here.Notice: do mask on sensitive data before share.
Regards,
Xiaoxin Sheng

anonymous · Answer

Thanks for the information on One Drive and Google Drive.&nbsp; I will prepare a sample data set and save it on probably one drive then I will send you the link.&nbsp;Thanks in advance for your assistance.Regards,&nbsp;

Forum Discussion

ranking a table or matrix

5 Replies

Related content

Matrix table

Matrix Report Ranking

Duplicate ranking

Matrix table

KPI level matrix table