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
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?)
right! it was very simple! Many thanks ;D