Dimension Limits on Bubble Charts

[hobanwashburne]

I have a bubble chart showing the count of times a product was ordered on the X-axis, the count of unique customers that purchased the product on the Y-axis, and the sum of the order quantity on the Z-Axis (bubble size).

Now I want to limit the data displayed to the top 10 values by quantity ordered (Z-Axis or 3rd Expression), but the Dimension Limits tab only uses the first expression (X-axis ~ count of times ordered).

How can I reduce the data displayed based on the quantity ordered?

[Anonymous]

Scott,

Try to replace your dimension, whatever it is, with a calculated dimension where you use rank function, i.e. where rank(<your 3rd expression>) <=10.

Regards,

Michael