Hello,
please check the attachment for details.
What i need is :
The sum of all the full_trade_amount for that route
The list of routes that share a customer with that route
The number customers shared with that route
The number of columns with data can vary so a route could share customers with many many routes so don't limit the number of columns for routes.