group by column table

[#1]

Hello,

I have this Charts->Table:

Country	Customer	Value
Germany	Customer 1	25
Germany	Customer 1	45
Germany	Customer 2	20
Austria	Customer 3	5
Austria	Customer 3	30
Hungary	Customer 4	45

How can I group customers like this?

Country	Customer	Value
Germany	Customer 1	70
Germany	Customer 2	20
Austria	Customer 3	35
Hungary	Customer 4	45

Thank you!

[MK_QSL]

T1:
Load Country, Customer, Value From Table;

T2:
Load Country, Customer, SUM(Value) as TotalValue Resident T1 Group by Country, Customer;

Drop Table T1;

[#3]

I am at the beginning of using these aplication, where should I insert the scripts  for T1 and T2 ?

Thank you!

[pathiqvd · Accepted solution]

Hi,

   Try  this ,

aggr(Sum(value),customer,country)

write this in measure

Regards,

[#5]

work, thank you!