We are building a marketing dashboard that includes multiple companies, each associated with their total media spend by category (e.g., insurance, retail, etc.). We would like to rank these companies in order of their media spend within each category. 

Is it possible to create a custom dimension or calculated field in Datorama/Marketing Cloud Intelligence (MCI) to achieve this ranking? If so, could you advise on the best approach or provide guidance on the necessary steps? 

Thank you.