Doing Sum according to one Parameter

[#1]

Hello Everyone,

I have a table with this kind of data:

Quantity	Parameter
8	X1
9	X2
2	X1
8	X3
8	X3

This is just a few entries but my table is really huge.

I would like to SUM all the quantities for each DISTINCT parameter and then to do Average Min and Max from this Sum.
for example in this situation I want my formula to calculate that :

X1= 10 , X2= 9, X3=16

Then I want a formula that would calculate the average : (10 + 9 + 16 ) / 3

The min would give: 9

And Max: 16

Do you know any way of doing it?
Thank you very much

[marcus_sommer · Accepted solution]

I'm not sure if I understand your question right, but try:

avg(aggr(sum(Quantity), Parameter))

min(aggr(sum(Quantity), Parameter))

max(aggr(sum(Quantity), Parameter))

- Marcus