Hello! I am trying to come with a total number based on region and type of project.
For example, the project type is new product, the region is APAC and the 1yr rev is $1M. I need a metric where the formula captures the same region, the overall number of project types and the overall revenue. Does that make sense? Here is an example