Forum Discussion
Helper IReport: How to display TOP 5 Result based on Status ?
Super Usereden
You may have more than one customer who falls into the top 4. If you have two customers who are ranked top one, they both come.
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
edenthat can be the case.
how to filter them based on any other criteria.. We can use start date , that whoever has early entry can be displayed in the chart
- Fowmy
@eden
I gave you the solution based on the sample data you shared and there was no date column to be included in the rank. Share a propper sample and show the expected output.________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
- eden
My intention was to filter the top 5 records based on their weightage in my whole table.. If two records carry same weightage we can use someother field to decide the winner..
Here we can use start date as a criteria as early start date will have highest priority in the chart
I am expecting something like below, Customer XYZ is not eligible as OIU,KJS as earlier start date