Stacking 4 columns

[ts3st1000]

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

[sunny_talwar]

okay

[ts3st1000]

I have just noticed a new table called LinkTable in the Data model viewer that is not connected to anything... do you think that could cause any issues. I already have few tables and they are all connected. thanks.