I can't find any equivalent of the Excel Pivot Table or Open Office Data Table features. I'd like to sum up my data grouped by values in various columns.
For example, if I have
A B C red left 2 red left 3 green left 4 green right 4
I want to be able to get
red green all left 5 4 9 right 0 4 4 all 5 8 13