You can try this.
SUM(IF [Metric Name] = 'Cancels' THEN [Metric Value] END)/SUM(IF [Metric Name] = 'Unit Sales' THEN [Metric Value] END)
This will be a separate calculated field and will not be part of the Metric Name field
Hey guys. thanks for the response to my initial question. I was looking to see if it's possible to not have it create another calculated field and to display that % separately, but was wondering if you've seen how to use 1 field to get this to work. Thanks for trying to help though!