Filter value based on static items

[Rosanero4Ever]

Hi all,

I'm trying to filter a report about the revenue.
I'd like to have a prompt like the following:
a) revenue<100
b) 100<=revenue<=1000
c) revenue>1000

If I'd like filter the revenue measure using the option a) and c), how can I write the filter statement in Report Studio?
At today, I write the following statement:
(?Range? = 1 and [Revenue]<100)
OR
(?Range? = 2 and [Revenue]>100 and [Revenue]<=1000)
OR
(?Range? = 3 and [Revenue]>1000)

where option a) is identified by the value 1, b) by the value 2 and c) by the value 3

In this case a radio button is displayed but I'd like a checkbox in order to select multiple options.

Can anybody suggest me any solution?
Thanks a lot in advance

[HalfBloodPrince]

Create a query Calculation in List query as  range and in your prompt query

If( revenue<100 ) then
(1)
else if( 100<=revenue<=1000 ) then
(2)
else if( revenue>1000 ) then
(3)
else
(null)
Then use this query calculation display in prompt query and add filter in list as Range in (?range?)

[Rosanero4Ever]

right! it was very simple! Many thanks ;D