This is something that is totally doable with a tool called Whaly (https://whaly.io).
They let you build custom reports and metrics through a powerful, yet simple, interface directly connected to CRM, product and marketing data. And they can let you build calculated metrics or more advanced operations such as roll-ups, lookups, etc.