By utilizing the aggregation and grouping features, you can establish groups within the Result Matrix and subsequently perform aggregation operations on these groups. Such as SUM, COUNT, etc.
Supported Aggregations
AVG
COUNT
MAX
MIN
SUM
Definition
def groupByData = api.newMatrix()
.withColumns('TextColumn1', 'TextColumn2', 'NumericColumn3', 'NumericColumn4')
.withRows(entries)
.withGroupBy(['TextColumn1', 'NumericColumn3'])
.withColumnAggregation('NumericColumn3', SUM)
.calculateGroupByData()