Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi,
Try this ,
aggr(Sum(value),customer,country)
write this in measure
Regards,
T1:
Load Country, Customer, Value From Table;
T2:
Load Country, Customer, SUM(Value) as TotalValue Resident T1 Group by Country, Customer;
Drop Table T1;
I am at the beginning of using these aplication, where should I insert the scripts for T1 and T2 ?
Thank you!
Hi,
Try this ,
aggr(Sum(value),customer,country)
write this in measure
Regards,
work, thank you!