Hi all,
is there a way to set a filter to show only top N results, for example I made a report that shows a chart with 40 bars,
so I want to do is to set the filter to show only top let's say 5 result.
Thank you
1 Answer:
Posted on June 9, 2017 at 7:32am
If you change the view type to a Crosstab, you can then right click on the measure column header in the crosstab and it will allow you to filter on the Top N or Bottom N values, as well as sort ascending or descending. If you do this and then change the view type back to a chart, your bar chart will retain these settings and just show the top N bars.
