Report to show customers with more than x records in parent

[Mili]

Hello,

We have table A parent with table B child (1 to many relationship). Customer ID is in child table. Report needs to display customer IDs with more than 10 records in parent A table.  Is it possible? If so, how would this be done within the reporting functionality of ServiceNow?

I have seen examples of getting x records from the child but not the other way around. I also have no control over how the system has been configured for our organization, so can't change the design. Task table seems to be the top most parent with task type = A or B.

Any help or guidance is greatly appreciated.
Thank you.

[Ankur Bawiskar · Accepted solution]

@Mili 

you can use scripted filter condition in reporting

Exploring Advance Reporting Conditions using Script 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏