Limit number of records in report
I am using Zoho Creator for project management and for each project I have a list of upcoming tasks and a deadline. I am trying to create a report that will show upcoming tasks for each project, but set a limit on the number of tasks displayed for each project. For example, if Project A has 10 upcoming tasks, I only want to see the next 3 of them with the newest first.
I know how to limit the number of records per page, but I'm looking to limit the number of records displayed for each project.
Any way to do this? Maybe some coding in the Definitions section?