CUMULATE on Multiple Dimensions (Using "on" operator), based on Ranking Metric

Hello, 
Here is my solution. You will need to create a new dimension called “Ranking Dimension”, which will be used to turn the numeric ranking into a dimension that can then be used for calculation. 
Here are the metrics that I created:

• MET_To_Cumulate
  • Dimensions: Region, Customer
  • Manual values based on your screenshot
• MET_Ranking
  • Dimensions: Region, Customer
  • Manual values based on your screenshot
• MET_Ranking_Dimension
  • Dimension: Region, Customer, Ranking Dimension
  • Formula: ITEM(TEXT(MET_Ranking), 'Ranking Dimension'.Name)
  • Note: This is where I use the new dimension I created. The list just contains items from 1-9. 
• MET_To_Cumulate_with_Ranking
  • Dimension: Region, Customer, Ranking Dimension
  • Formula: MET_To_Cumulate[BY:-> MET_Ranking_Dimension]
• MET_Cumulated_Values
  • Dimensions: Ranking Dimension
  • Formula: CUMULATE(MET_To_Cumulate_with_Ranking[REMOVE:Customer, Region], 'Ranking Dimension')
  • Values are cumulated based on the Ranking Dimension
• MET_Cumulate_on_Rank
  • Dimension: Region, Customer
  • Formula: MET_Cumulated_Values[BY:MET_Ranking_Dimension]
  • End result, which will match your screenshot

Hope this helps :) 

Hello @Lehtohen !

Thank you very much. In fact, this was one of the alternatives we found, and as a result, we created this post. The customer data changes quite frequently, and we would need to do large imports on a regular basis. Additionally, our application is already quite large (+900 metrics, not counting that we use the metrics as often as possible by renaming, 'show as value of,' etc.). Customers number around 800 records, and regions have about 20 records, which would also be a fairly large dimension

That is indeed the best response; however, I will wait a bit longer in case someone has an alternative. Again, I appreciate your detailed reply

Regards,
Agarneri