sales of Company situated in two different country

[BK1312]

I have Combine Data for a Company whose Two Different Branches in Different Country 

How to differenciate their Sales ?

[brunobertels]

Hi 

"I have combine ".. I assume that you combine 2 tables 

If so .. 

then add a dummy dimension in each table like that : 

tablea:

load 

'Country 1' as Country, 

... 

from ... ;

tableb: 

load 

'Country 2' as Country, 

... 

from ... ;