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?

[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.

[Mattsco · Accepted solution]

Hi Simon, 

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