Display top 10 highest values
829439Apr 27 2012 — edited Apr 27 2012Hi All,
Please help me on how to achieve this.
I have a report and a db prompt in my dashboard. Based on the prompt selected and given the GO button, the report gets filtered accordingly.
Now what i want is , I wanted to filter only the Top 10 values of a particular column in my report when the prompt is given go button.
For ex, say there is a report with Name, EMp No, Hours Booked and a prompt with dept column.
When a particular dept is selected from the prompt and given go, the report should display only top highest 10 values of the Hours Booked corresponding to that particular dept and not display everything.
How can i achieve this?
Regards
Gowrish