Chart Display by Value

[#1]

I have a chart with a company name as a dimension and average revenue as an expression.  I want to make a graph that will only display companies that have an average revenue over a particular value.  I cant seem to create any dimension that will separate the companies by value(if statements), and I cant find a way to only display certain expression values (because hide zeros only works for dimensions.  Is there anyway for me to write a dimension that is based off the Avg Rev expression, OR is there anyway to only display certain expression values? 

Thanks, 

[SunilChauhan]

sort -> Y-axis-> check this

hope this helps

[#3]

I have found the area under sort to enter an expression.  What should my expression look like if I only want to display companies with a avg rev higher than 100?

[#4]

Not sure what version you are using but in QV 11 this is easily done with Dimension limits.