Assume I have a table like the following:
Mammal | Cow | 17 Mammal | Horse | 5 Mammal | Pig | 11 Bird | Duck | 12 Bird | Goose | 8 Fish | Sturgeon | 3 Fish | Carp | 14 Fish | Trout | 26
I would like to calculate sums across the third column, based on the value of the first. Like:
Mammal | 33 Bird | 20 Fish | 40
In a SQL database I would just do
SELECT A, SUM(C) FROM table GROUP BY A;
How can I automate this in Calc? Auto-update (sum changes as soon as I change anything in the first table) would be nice, but is not mandatory.