hi i have requirement
i created a report with data items .eg: branch name,branch id,revenue.
in this report i want to find out the top 'x' records based on prompt selection.for example
i added static choice to my value prompt like
top 10 revenue generated branches,
top 20 revenue generated branches,
top 30 revenue generated branches,
top 'x' revenue generated branches,
based on prompt selection i want report output.plz reply me ASAP.
thanks in advance for your reply
thanks
vamsi
hi I'm sorry,
i got solution but still have some problem.
>i created report with that dataitems(branch id,branch name,revenue)
>i created a calculated column like' rank of revenue'
rank([revenue])
>i created a dynamic filter on ' rank of revenue'column
>i change aggregation function to After aggregation function
>im getting the text prompt
but here i want value prompt drop down list insted of using textbox prompt.
how can i assign that calculated column to value prompt.i dont use static choices again.i want to show the values which is located in calculated column. we can use static choices but i have 2000 records.so its difficult to me add 2000 records.
how can we solve this.
plz reply me ASAP