group-sum

pebblestream:group-sum("Last name", "First name", ... "Amount")

📘

A note on group-sum's syntax

group-sum will always sum by the last parameter in the parameter list, and group by all the preceding parameters. So in the above example "Amount" is the column to be summed, whereas "Last name", "First Name", and all other preceding parameters are used to group.

❗️

Limitation

This directive cannot be paired with the group, group-unique, or group-ratio directives.

Example

Consider the worksheet Transactions

Apply the following directive declaration:

pebblestream:from(Transactions)
pebblestream:group-sum("Last", "First", "Transfer")

to obtain the Totals worksheet.