CJ, I think in this case "count" is the document count, and Profits is the Sum of a field. So a scripted field can't work because each document represents a count of 1.
Sharon, I think you can get the average if you're OK with having it on another visualization (and then you could have your current one and this average one next to each other on a Dashboard).
Can you try something like this?
- Change your Metric from Count to Average and select your Profits field.
- Split Rows by your Country
- Split Rows again by your Region
- Save this as a new Visualization name "Avg Profits" and then add your existing visualization and this new one on a dashboard together. You might need to set the Order By for your metrics to Term and use the Country and Region to make it match your first chart.
