Add aggregations to a column

UserBird

If I have data like this:

A 1
B 2
A 2
B 3

I want to create a third column that would produce either sum, min, max, avg over first column.
Example for max:

A 1 2
B 2 3
A 2 2
B 3 3



How can I do it in DSS?

Mattsco

Hi Simon,

You could do a grouping recipe and then a join recipe.

jereze

Hi Simon,

Hum, you could do that in Python, R or SQL.

Personally, I would use Window Functions in SQL. If you are working on Mac OS X, here is an easy way to install PostgreSQL on your mac.