Compare two sales values, one more than, one less than, to view results

[StuartOxley]

Hi,

I would like to know how I can compare two sales values based off of two dimensions and one measure.  

Dimension: Product

Dimension: Quantity

Measure: Amount CYTD

I'd like to find products equal to or above $1,000 dollars and then enter a 2nd value to be equal to or less than $500 dollars, for example.  

Could these be put into a slider of some sort and how?  

I can then view which products are selling and which are not based on these values.  

I hope this makes sense.

Kind regards, Stuart

[Vilo]

Do you have some sample data I could look at?

[StuartOxley]

I've attached some sample data.  

I select a value equal to or higher (>= ) than an amount I enter, for example: $3,499.99.

I then see the products which fall into this category.  

I then want to enter another value equal to or less than (<=)

$400.98. 

To view products which fall into this category.

This will show me the results of the two products and tell me what quantities have been sold.