Control Over Predominant Visual Property & Y-Axis Property on Column Report

SlimBob

I have a column report that displays deal owner, count of deals, and amount in company currency, measured by count of deals and then amount in company currency (total). In display options I have sort set to count of deals.

 

The resulting column graph always shows the amount in company currency on the y-axis and the predominant visual element is the amount of company currency as a result of that.

 

This means the large visual bar is based on amount of company currency, and there is no way to change that such that the count of deals is on the y-axis, displayed as the large visual bars, and thus the predominant visual property.

 

For this report, at a glance, I'm concerned with the count of deals, not how much those deals are worth. The amount is a secondary metric.