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
You could eliminate the filter and then suppress display of the rows based on which choice the user makes.
- 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