Prompt: default select top six countries

[Chandrasekar]

Hi All,
I want to develop a sales revenue report. In a prompt need to select country and default selection as top six revenue countries.

If it is possible to fix default selection in prompt. I am using relational model.

Please give me the suggestion.

Thanks & Regards,
CHANDRASEKAR

[iceacman]

if your prompt is used to filter your query with revenue, then no.
if not , then possible, you will have to mix your prompt query with your revunue query, order the combined query by the rank of revenue

[Chandrasekar]

Hi iceacman,

Thanks for your reply. I create two report pages then used java script. After i hide the dummy page. Now it works.

Regards
CHANDRASEKAR

[iceacman]

good to know that you solved it
just wondering if it could be better to use two queries rather than two page+JS, LOL