Question
3
Replies
729
Views
Posted: September 24, 2018
Last activity: October 11, 2018
Closed
Solved
Limiting results to top 5
Hi,
I want to limit the amount of results that the report definition pulls by the top 5 columns that result the most (ex. Top 5 fast food restaurants that sold the most burgers instead of displaying stats for all fast food restaurants) because in the picture provided, there are a lot of results that produce no results and can be omitted. Can someone be of aid?
Thanks
Do you want to show it in a report browser or section data grid.
If its not in report browser then you can use a data page and filter first 5 results in data page post processing.
For report browser you can try using 'Display Top ranked X rows Overall based on 'XXXX' option. This is at the very bottom of the Query tab. I know this works for a normal report but need to check for a summary chart.
Other option is to try to filter out rows which are having 0 count using sub report.
Regards,
Aniket