How to get top 5 records based on count column in Report Definition: Pega 8.4
We have an application say ABC which has 300 users who will create cases regularly. I want to fetch top 5 users who created the highest number of cases, and display the result in bar chart. The chart X-axis shows User ID and Y-axis shows Count of Cases created by them.
Currently i am just displaying the chart with all User ids and count of cases created by each user. But i want to get only top 5 users who created highest cases using Report Definition. Can anyone suggest how to achieve it.