Hi, in the load editor I am loading and reading a table from the database that looks like this:
| Country1 | Country2 | Sales1 | Sales2 |
| UK | Japan | 100 | 1000 |
| Germany | France | 110 | 1100 |
| France | Malaysia | 120 | 1200 |
| Italy | Germany | 130 | 1300 |
Where Sales1 is for Country1, and Sales2 is for country2.
I would like to display the above data in a chart of Sales by Country using a table similar to this:
| Country | Sales (Sales1 + Sales2) |
| UK | 100 |
| Germany | 1410 |
| France | 1220 |
| Italy | 130 |
| Japan | 1000 |
| Malaysia | 1200 |
Where I sum Sales by country.
Could you please suggest a solution to this. Thanks very much.
Regards,
Rachid
