Find the sum of a column depending on the value of a field

[#1]

Hiii !

Another little problem with a table... I have a table with 2 columns :

P	Value
P1	12
P1	6
P1	2
P2	3
P2	27

And I want this table

P	Total Value
P1	20
P2	30

How can I calculate the sum of my values for each "P" ?

I don't know if I'm very clear... But I really hope that you can help me 😃

[CELAMBARASAN · Accepted solution]

Hi,

     Use Straight table

     Have P as Dimension.

     Sum(Value) as expression

Celambarasan

[#3]

Hum... So easy... And I tried to make  a script for each value in a table... hum

Thank you for your precious help !!!