ranking and static choice with rank interval

[tequila]

hello,

i have list with rank function on revenues and static choise in a prompt i.e. rank 1-10, 11-20 etc.

Dataelement
rank([revenues])

Detailfilter

if (?Ranking? = 1)  then ([Rank] between 1 and 10) else ([Rank]between 11 and 20)

Problem

when i choise 1-10 the ranking count RANK and revenues 1-10, but when i choice 11-20 the RANK count again rank 1-10 (revenues 11-20) and not from 11-20.
How can I make that the rank not count again from the beginning also continues count the RANK.

the report is in list and relational package

thnx

[Lynn]

You could eliminate the filter and then suppress display of the rows based on which choice the user makes.

[hespora]

- In the Queries view, add an empty query

- drag your existing query to the right hand side of the new one. (result should look like in the attachment)

- go inside your new query and pass all data items, including the rank you built, from the existing query

- apply the filter from your prompt on the new query, and remove it from existing query

- go to your list object and change the "Query" property from existing query to new query