group-ratio

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

All rows with the same "Last name" and "First name" are put next to each other with their "Amount" values replaced by their "Amount" value divided by their group's summed "Amount" value

📘

When the group's sum is zero, all ratios are assigned the value of zero.

❗️

Important

Can't be used with the "group", "group-unique", or "group-sum" directives.

Example

Consider the worksheet Deposits

Using the following directive:

pebblestream:from(Deposits)
pebblestream:group-ratio("Last", "First", "Deposit")

derives the worksheet Ratio Deposited