Prompt on Rank

[net1212]

Im haveing a rank column,i want to filter the report using rank prompt.

eg:
prompt will be a static choice
1 to 5
6 to 10
11 to 15

depending on user selection the report should be filter.

it should show only the range selected.

Thanks in advance.

 

[Nuffsaid]

Your static prompt will display as shown however in the USE box set it up as follows;

DISPLAY USE
1 to 5 1
6 to 10 2
11 to 15 3

Then for your filter

case ?Rank?
when 1 then([Rank] between 1 and 5)
when 2 then ([Rank] between 6 and 10)
else ([Rank] between 11 and 15)
end

Set the properties of this filter to "After Aggregation".



Nuffsaid.

 

[net1212]

Thanks a lot it works..