Need to create a report that displays the 5 Oldest catalog task

[keshav77]

Need to create a report in ServiceNow that will display the following two things. The 5 oldest catalog task and  These need to be grouped by Assignment group. 

[Tanushree Maiti]

Hi @keshav77 

• Navigate to Reports > Create New.
• Report name: Oldest 5 Catalog Tasks by Group.
• Source type: Table.
• Table:sc_task
• Click Next. 
• Type: Select List (this is best for viewing specific record details).
• Click Next.
• • Filter: Set Active is true
  • Grouping:
    • Find the Group by dropdown.
    • Select Assignment group
• Limit to Top 5 Records

  option 1 : List View Limit (Recommended for "Oldest")

  • Stay with the List report.
  • Add Sort a to Z
  • 
  • Update related list condition. set the value to 5 as per screen shot.
  •