I got problem in architecture, it has the same amount in each territory.
I got a problem, in each brand of each territory outputs the same sales. Below is the sample table fields.
Product Code Territory
Sales Product Code
As you can see in the fields, it doesnt have "territory" field in the Transactions table, that is why it outputs the same sales in each territory. What should I do? Help me please, need it urgent! Thanks.
Given the nature of the data (no Territory in Transactions table) you cannot tell anything about the Product Sales by Territory. If you had it, the right thing to do would be concatenation of both tables, as Phani said.