Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I got problem in architecture, it has the same amount in each territory.
Sample Output:
Territory | Brand | Sales | Target |
---|---|---|---|
A | Brand A | 13,000 | 16,000 |
Brand B | 6,000 | 5,000 | |
B | Brand A | 14, 000 | 10, 000 |
Brand B | 50, 000 | 55, 000 | |
C | Brand A | 10, 000 | 15,000 |
I got a problem, in each brand of each territory outputs the same sales. Below is the sample table fields.
Transactions: Targets:
Product Code Territory
Sales Product Code
Target Amount
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.
Best Regards,
Bill
Are you doing a left join with Targets table?
Do the concatenation and ignore the fileds that doesnt need in set analysis...
Post a sample..if possible...
Regards,
phani
Hi Bill,
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.
Regards,
Michael
Hi Guys,
That's what Im thinking, there is no territory in transaction table so there's no chance of getting sales per territory.
Thanks for the reply.