Allow Filters for Top % or Top number similar to excel pivot table choices
In excel I am able to view data based on top % or top # and I enter a value for say top 5, top 10, top 20. I don't see this functionality unless I'm missing something. In particular when analyzing spend data on 1000s of suppliers one might only care about the top 10 etc. there's no function to support this.
Nathan Waterman commented
Does this work for graph views? I can't see the option to choose how many rows are visible.
Derrick Kotlus commented
The easiest way to do this would be to sort your view by the column you would like to rank so the highest numbers are at the top(click on the header of the field twice). You can then change the "show rows per page" setting to 10. This will show you only your top ten records. Hope this helps, please let us know if you have any further questions!