I've created a scatter chart that plots customers by transaction date and sum of sales. I'd like to limit this chart to large transactions (over $250k). I thought that I would be able to simply use the Dimension Limits tab to accomplish this. Unfortunately, I realized that the Dimension Limits tab in the chart properties only applies to the FIRST expression. This means I had to promote my sum of sales expression to the top to allow the dimension limitation to work which caused my axes to flip.
Is there a work-around to this functionality? Can I force my scatter to flip axes assignment? Should I be using Dimension Limits at all in place of set analysis?
Thank you in advance for any consideration.