How to summarize quantities of sold products by grouping by category

Hi,

I have a list of sold products and quantities.

Product Name = Category+Suffix

I want to summarize the sold quantities by Category.

Is there a function Deluge to do this ?

From :

{"productName":"CategoryA_suffix1","quantity":"QA1"},

{"productName":"CategoryA_suffix2","quantity":"QA2"},

{"productName":"CategoryA_suffix3","quantity":"QA3"},

{"productName":"CategoryB_suffix1","quantity":"QB1"},

{"productName":"CategoryB_suffix4","quantity":"QB4"},

{"productName":"CategoryB_suffix6","quantity":"QB6"}

To :

{"CategoryName":"CategoryA","quantity":"sum(QA)"},

{"CategoryName":"CategoryB","quantity":"sum(QB)"}

Zoho Desk Resources

Desk Community Learning Series
Digest
Functions
Meetups
Kbase
Resources
Glossary
Desk Marketplace
MVP Corner
Word of the Day

Topic Participants
Ludovic M
Sathish M

Sticky Posts
Introducing Bigin 360: Our new pricing edition with increased feature limits and pre-installed toppings
Dear Biginners Club, Today, we're pleased to launch a brand-new pricing edition called Bigin 360, our highest pricing edition that will sit on top of Express and Premier editions. It's been over four years since our launch, and we're receiving some great
Announcing #BiginnersClub meetups in US, Middle East, India & UK (Free Event)
Exciting news, Bigin enthusiasts! #BiginnersClub meetups are back, and we're hitting some major cities this time, starting from October. Here's what you can expect: Meet our experts face-to-face Deep dive into Bigin and its advanced features Personalised
[New] Create invoices and contracts in minutes with Zoho Writer's Merge Templates for Bigin!
Do you often find yourself manually entering customer information in your business documents like invoices and contracts? This can be a time-consuming process that can take up valuable time from your business operations. With Zoho Writer's Merge Templates
Introducing Forms: Streamline data collection with Bigin's new form builder.
Hello everyone, Bigin's web forms just got a makeover! We are excited to introduce Forms: an online form builder designed to meet all your data collection need. This revamp was inspired by your feedback, resulting in an upgraded and versatile version
Announcing #BiginnersClub meetups in India, Middle East & Africa, and UK
Yes, you heard it right! #BiginnersClub meetups are back. Whether you're a long-time customer looking to learn more about Bigin, or a new customer trying to explore Bigin, our in-person meetup is definitely the right place to get a deeper understanding