topic group by column table in App Development

group by column table

Sat, 29 Jul 2017 11:46:45 GMT

Hello,

I have this Charts->Table:

How can I group customers like this?

Thank you!

MK_QSL — Sat, 29 Jul 2017 17:15:27 GMT

T1:
Load Country, Customer, Value From Table;

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

Drop Table T1;

Sat, 29 Jul 2017 17:28:40 GMT

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

Thank you!

pathiqvd — Sun, 30 Jul 2017 05:18:20 GMT

Hi,

Try this ,

aggr(Sum(value),customer,country)

write this in measure

Regards,

Mon, 31 Jul 2017 08:14:51 GMT

work, thank you!