Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Grouping and counting in one saved search.
I have two saved customer searches that I'd really like to combine into one. Right now I need to manually stitch them together once a month.
The first search lists our customers and the number of contacts each customer has. The second search lists each customer and every contact for that customer. So ... right now I have something like this:
Search 1:
Apple Computers | 3
Sears Canada | 1
Volkswagen Canada | 2
Search 2:
Apple Computers | Mary Smith
Apple Computers | Jimmy Joe
Apple Computers | Irwin Martens
Sears Canada | Irene Rempel
Volkswagen Canada | Mark Friesen
Volkswagen Canada | Ranjit Singh
And I would like to see this:
Apple Computers | Mary Smith | 3
0