Posted: 24 Sep 2018 9:04 EDT Last activity: 11 Oct 2018 8:36 EDT
Limiting results to top 5
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?
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.